SQL Plus
From TekiWiki
This whole wiki has now moved to http://www.springboardsolutions.com/wiki
Go to this page SQL Plus
(Created page with "SQL Plus is Oracle's supplied interactive SQL client. In later versions of Oracle, for interactive SQL queries, SQL Developer is a better GUI. However, to run scripts and run SQL...") |
|||
| Line 1: | Line 1: | ||
SQL Plus is Oracle's supplied interactive SQL client. In later versions of Oracle, for interactive SQL queries, SQL Developer is a better GUI. However, to run scripts and run SQL as part of batch scripts, SQL Plus is your man. | SQL Plus is Oracle's supplied interactive SQL client. In later versions of Oracle, for interactive SQL queries, SQL Developer is a better GUI. However, to run scripts and run SQL as part of batch scripts, SQL Plus is your man. | ||
| - | + | ==Setting Up SQL Plus== | |
SQL Plus has set of options that can be used to tailor the output. You can set these up to allow you to display things on screen or to create batch files. | SQL Plus has set of options that can be used to tailor the output. You can set these up to allow you to display things on screen or to create batch files. | ||
| - | + | ===Create a file with only data=== | |
To remove all headings, feedback etc. from the output. If you have just started SQL Plus: | To remove all headings, feedback etc. from the output. If you have just started SQL Plus: | ||
