Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQLPlus - has me stumped (re-repost - calendar reset wrongly).
"Chris ( Val )" <chrisval_at_bigpond.com.au> wrote in message
news:X7Xpe.11492$F7.8366_at_news-server.bigpond.net.au...
|
| "Paul" <paulsnewsgroups_at_hotmail.com> wrote in message
| news:n57ea1h6gkn46tqjp92uqbbd3846hs1m2u_at_4ax.com...
||
||
|| Hi all,
||
||
|| Am trying to learn Oracle at home (between jobs!).
[snip]
| Try this:
|
| set linesize 100
| set serveroutput on format wrapped
| column COMMENTS format a50
| select * from dictionary;
|
| Btw, you should be able to set your command window up
| to offer a scroll bar at some point.
Sorry, I forgot to mention, that you can put the above statements into a file called 'glogin.sql', and they will be set as defaults for when you use SQL*PLUS.
On my machine, this file is here:
"C:\oracle\ora92\MyHome\sqlplus\admin\glogin.sql"
Yours may differ, of course depending on machine.
Cheers,
Chris Val
Received on Thu Jun 09 2005 - 08:18:52 CDT