SQL Plus
From TekiWiki
This whole wiki has now moved to http://www.springboardsolutions.com/wiki
Go to this page SQL Plus
(→Set a Spool Filename with Database Name and Timestamp) |
|||
| 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=== | ||
| Line 77: | Line 78: | ||
spool off | spool off | ||
</pre> | </pre> | ||
| + | |||
| + | |||
| + | Articles about SQL: | ||
| + | |||
| + | * [[SQL Plus]] | ||
| + | * [[Creating Comma Seperated Lists]] | ||
| + | * [[Sampling a Table]] | ||
| + | * [[Tree Queries]] | ||
| + | |||
| + | * [[Example Country Table]] | ||
| + | * [[SQL Developer]] | ||
