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.
