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

On Wed, 08 Jun 2005 17:29:12 +0100, Paul <paulsnewsgroups_at_hotmail.com> 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...

The datatype of the comment column probably is a long. You can verify this by issuing
describe <table>
If so you need to issue
set long <any high number>
to see all of it.

The output will wrap though, sql*plus output has never been scrollable.

--
Sybrand Bakker, Senior Oracle DBA