sqlplus
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
| sqlplus [2015/07/17 14:05] – created z0hpvk | sqlplus [2025/03/08 22:24] (current) – external edit 127.0.0.1 | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ==== SQL*Plus ==== | + | ===== SQL*Plus |
| - | === glogin.sql === | + | ==== glogin.sql |
| You can alter the default prompt and editor for SQL*Plus using the glogin.sql file. \\ | 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 | This can be found at $ORACLE_HOME\sqlplus\admin | ||
| Line 6: | Line 6: | ||
| set sqlprompt " | set sqlprompt " | ||
| You can add here any other " | You can add here any other " | ||
| + | |||
| + | ==== 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| | ||
| + | |||
sqlplus.1437141947.txt.gz · Last modified: (external edit)