Re: Simple SQLPlus question - has me stumped (repost - other post was dated 2000).

Paul wrote:
>
> 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?
>
> Paul...
>
> --
>
> plinehan __at__ yahoo __dot__ __com__
>
> XP Pro, SP 2,
>
> Oracle, 9.2.0.1.0 (Enterprise Ed.)
> Interbase 6.0.2.0;
>
> When asking database related questions, please give other posters
> some clues, like operating system, version of db being used and DDL.
> The exact text and/or number of error messages is useful (!= "it didn't work!").
> Thanks.
>
> Furthermore, As a courtesy to those who spend
> time analysing and attempting to help, please
> do not top post.

col comments format a80

will make it wrap every 80 bytes

hth
connor

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com


"Semper in excremento, sole profundum qui variat."

------------------------------------------------------------