edit $ORACLE_HOME/sqlplus/admin/glogin.sql
– parm: my specific stuff
ALTER SESSION SET nls_date_format = ‘HH:MI:SS’;
SET SQLPROMPT “_USER’@'_CONNECT_IDENTIFIER _DATE> ”
SET PAGESIZE 24
SET LINESIZE 78
This can also be set in user’s home directory, but will only be run if user connects to sqlplus from their home directory.
you can use the SPOOL command to save the output into file and send it directly to the printer, for file follow the instruction:
SQL>SPOOL filename
SQL>select yada yada yada;
SQL>SPOOL OFF
[oracle@localhost bin]$ sqlplus /nolog
SQL*Plus: Release 11.1.0.6.0 – Production on Wed Aug 27 19:41:29 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
SQL> connect sysdba/fraggle as SYSDBA;
Connected.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
