This content has been marked as final. Show 2 replies
Formatting SQL*Plus Reports
SQL*Plus Configuration (or using a login.sql file so every time you start sqlplus your preferences are loaded)
Set off with a wider console using SET LINESIZE 180. Then add few useful settings like SET PAGES 50000 for having headers printed only once every 50k rows, SET TAB OFF to prevent replacing of multiple spaces with tab characters plus SET TRIMOUT ON and SET TRIMSPOOL ON to get rid of trailing spaces at line ends.
To format individual columns use column clause:
Finally, to make these persistent, place them in either site global configuration script under $ORACLE_HOME/sqlplus/admin/glogin.sql or local one at ~/login.sql.
column first_name format a20 column last_name format a20 column email format a30