How To Get Readable Results in sqlplus
Use SQL Developer wherever possible. It is much better than sqlplus and has excellent tools for browsing the database and debugging.
If you don’t have access to SQL Developer, you can format the sqlplus output as follows.
1set linesize 400
2set pagesize 1000
3
4-- Run a separate command for each column to be displayed, as follows.
5-- a20 means the column is 20 characters wide. Use this format for varchar2 fields.
6-- For numbers, each digit is represented by a 9
7
8column OBJECT_NAME format a20
9column OBJECT_TYPE format a20
10column STATUS format a20
11column PRICE format 999.99