Re: sys.col

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Sat, 22 May 2004 19:08:57 GMT
Message-ID: <dzNrc.3753$o97.1452@nwrddc01.gnilink.net>

"steve43" <stephen_at_johnstontrading.com> wrote in message news:818946ce.0405221106.6abbf9e1_at_posting.google.com...
> hi guys
>
> im real new and this is a course assignment question i cant figure
> out.
> i need to mimic the desc statement on a table using sys.col. I can get
> the info ok but it doesnt read well( wraps). is there any way to
> format the output for the follwoing like desc tablename?
>
> select cname,nulls,coltype,width from sys.com where tname = 'TITLES';
>
> Steve

Grab the sqlplus guide from tahiti.oracle.com

You'll find all the formatting commands out there.

col colname format a10
set linesize 120 pagesize ......

Anurag Received on Sat May 22 2004 - 14:08:57 CDT