Re: sys.col

From: Hans Forbrich <forbrich_at_yahoo.net>
Date: Sat, 22 May 2004 19:29:19 GMT
Message-ID: <jSNrc.12452$SQ2.6004@edtnps89>

steve43 wrote:

> 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

If you are allowed to use SQLPlus, then it's time to look at the free SQLPlus Reference manual available at http://docs.oracle.com - look up COLUMN formatting.

/Hans Received on Sat May 22 2004 - 14:29:19 CDT