Re: SQLPlus - has me stumped (re-repost - calendar reset wrongly).

From: Chris \( Val \) <chrisval_at_bigpond.com.au>
Date: Thu, 09 Jun 2005 13:04:55 GMT
Message-ID: <X7Xpe.11492$F7.8366@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!).
|
|
| Log on as scott/tiger.
|
|
| set linesize 10000
| set pause on
| set serveroutput on
|
| select * from dictionary
|
| > TABLE_NAME COMMENTS
|

 > ---------------------------------------------------------------------------------------------------


| > ALL_ALL_TABLES                 Description of all object and relational tables accessible 

to the use
|
|
| But I can't scroll over to the right any further than this, despite
| having a linesize of 10000. Can anybody tell me what I'm missing,
| thanks?

[snip]

Paul,

On my implementation: 9ir2 - 9.2.0.6.0

SQL> desc dictionary

 Name                       Null?    Type
 ----------------------------------- ---------------
 TABLE_NAME                          VARCHAR2(30)
 COMMENTS                            VARCHAR2(4000)

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.

Hope this help's,
Chris Val Received on Thu Jun 09 2005 - 08:04:55 CDT