DB Wiki

SQL*Plus

You can alter the default prompt and editor for SQL*Plus using the glogin.sql file.
This can be found at $ORACLE_HOME\sqlplus\admin

define _editor=vi
set sqlprompt "_USER'@'_CONNECT_IDENTIFIER> "

You can add here any other “set” command that you find yourself using continuously.

Command	Description	Version
SET FEEDBACK ONLY	No data is returned, just the number of rows	12.2
SET MARKUP CSV ON	Output in CSV format	12.2
SQLPLUS -F	Change parameters to improve performance (includes pagesize, arraysize and statementcache	12.2
SET LINESIZE WINDOW	Dynamically alter output to fit size of window	18
SET ROWLIMIT n	Limit the number of rows displayed by the query	18