SQL Plus
From TekiWiki
This whole wiki has now moved to http://www.springboardsolutions.com/wiki
Go to this page SQL Plus
| Line 1: | Line 1: | ||
| - | SQL*Plus is the [[Oracle Database]]'s supplied interactive SQL client. In later versions of Oracle, for interactive SQL queries, SQL Developer has a better GUI. However, to run scripts and run SQL as part of batch scripts, SQL Plus is your man. | + | SQL*Plus is the [[Oracle Database]]'s supplied interactive SQL client. In later versions of Oracle, for interactive SQL queries, [[SQL Developer]] has a better GUI. However, to run scripts and run SQL as part of batch scripts, SQL Plus is your man. |
==Setting Up SQL Plus== | ==Setting Up SQL Plus== | ||
| Line 5: | Line 5: | ||
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=== | + | ===Create a file with only data from your SQL=== |
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: | ||
| Line 24: | Line 24: | ||
</pre> | </pre> | ||
| + | The difference between long and maxdata (in the above example, 60,000-55,000=5,000) gives the space for the other columns in the rest of the row | ||
===Changing the Prompt=== | ===Changing the Prompt=== | ||
