sqlplus
This is an old revision of the document!
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.
| 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 |
sqlplus.1581520706.txt.gz · Last modified: 2025/03/08 22:23 (external edit)