DB Wiki

User Tools

Site Tools

Trace:
sqlplus

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
sqlplus [2015/10/21 10:18] – external edit 127.0.0.1sqlplus [2025/03/08 22:24] (current) – external edit 127.0.0.1
Line 6: Line 6:
 set sqlprompt "_USER'@'_CONNECT_IDENTIFIER> "</code> set sqlprompt "_USER'@'_CONNECT_IDENTIFIER> "</code>
 You can add here any other "set" command that you find yourself using continuously. 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|
 +
sqlplus.1445422736.txt.gz · Last modified: 2025/03/08 22:23 (external edit)