Setting SQLPLUS defaults

SQLPLUS Default Settings

Edit $ORACLE_HOME/sqlplus/admin/glogin.sql

--alter session set NLS_DATE_FORMAT='DD-MON-YYYY HH24:MI:SS';

define_editor='vi'
set sqlprompt '&_user:&_connect_identifier > '
set pagesize 50
set linesize 140