SQL Plus
From TekiWiki
This whole wiki has now moved to http://www.springboardsolutions.com/wiki
Go to this page SQL Plus
| Line 16: | Line 16: | ||
===Writing out "LONGs"=== | ===Writing out "LONGs"=== | ||
| - | To increase the length of a LONG displayed in SQL Plus: | + | To increase the length of a LONG column displayed in SQL Plus: |
<pre> | <pre> | ||
| Line 40: | Line 40: | ||
<pre> | <pre> | ||
set sqlprompt "_USER'@'_CONNECT_IDENTIFIER> " | set sqlprompt "_USER'@'_CONNECT_IDENTIFIER> " | ||
| + | </pre> | ||
| + | |||
| + | ===Editing Your SQL=== | ||
| + | Use your favourite text editor to edit files - for instance - TextPad: | ||
| + | |||
| + | <pre> | ||
| + | define _editor=C:\Progra~1\TextPa~1\Textpad.exe | ||
| + | </pre> | ||
| + | |||
| + | ===Show Output from PL/SQL=== | ||
| + | To see output from PL/SQL (and see as much as you can): | ||
| + | |||
| + | <pre> | ||
| + | /* Pre 10gR2 client */ | ||
| + | set serveroutput on size 1000000 | ||
| + | </pre> | ||
| + | |||
| + | <pre> | ||
| + | /* Post 10gR2 client */ | ||
| + | set serveroutput on size unlimited | ||
</pre> | </pre> | ||
