Sometimes output from Sqlplus is a little bit confusing. Fortunately there are ways how to improve that.

• column column_name format a20 – make the column column_name smaller (20 characters), only for strings and dates
• column column_name format 99990 – make the column column_name smaller (5 digits), for numbers
• set pagesize 5000 – set the bigger page size
• column column_name noprint – no print column column_name
• set line 120 – set line length to 120
• set long 10000 – print whole long text, for example in CLOB