Set SQL*PLUS
SQLPROMPT &_user : Who is connected (10g and +). &_CONNECT_IDENTIFIER : Which Database you are connected. Eg : SQL> set sqlprompt '&_CONNECT_IDENTIFIER@&_user>' PADOVA@SYS > TRIMSPOOL – TRIMOUT SET TRIMOUT ON or SET TRIMSPOOL ON removes trailing blanks at the end of each displayed or spooled line. SQL> set lin 80 SQL> set TRIMSPOOL OFF SQL> spool prueba04 . txt SQL> select '12345' cmp from dual ; cmp ----- 12345 SQL> spool off; bash - 3.2 $ wc - c prueba04 . txt 293 prueba04 . txt < ----- 293 characters SQL> set lin 80 SQL> SET TRIMSPOOL ON SQL> spool prueba02 . txt SQL> select '12345' cmp from dual ; cmp ----- 12345 SQL> spool off; bash - 3.2 $ wc - c prueba02 . txt 69 prueba02 . txt < ----- just 69 characters GLOGIN.SQL $ORACLE_HOME/sqlplus/admin/glogin.sql All