===== SQL*Plus ===== ==== glogin.sql ==== 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. ==== New Features ==== ^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|