SQL Plus
From TekiWiki
This whole wiki has now moved to http://www.springboardsolutions.com/wiki
Go to this page SQL Plus
| Line 12: | Line 12: | ||
set pages 0 | set pages 0 | ||
set feedback off | set feedback off | ||
| + | </pre> | ||
| + | |||
| + | ===Writing out "LONGs"=== | ||
| + | |||
| + | To increase the length of a LONG displayed in SQL Plus: | ||
| + | |||
| + | <pre> | ||
| + | set long 55000 | ||
| + | set arrays 1 | ||
| + | set maxdata 60000 | ||
| + | </pre> | ||
| + | |||
| + | ===Changing the Prompt=== | ||
| + | |||
| + | To put the database name into the prompt in SQL Plus (prior to Oracle 10g): | ||
| + | |||
| + | <pre> | ||
| + | column global_name new_value gname | ||
| + | |||
| + | select name || '> ' global_name from v$database; | ||
| + | |||
| + | set sqlprompt '&gname' | ||
| + | </pre> | ||
| + | |||
| + | This is made a little simpler in 10g and higher: | ||
| + | |||
| + | <pre> | ||
| + | set sqlprompt "_USER'@'_CONNECT_IDENTIFIER> " | ||
</pre> | </pre> | ||
