Re: PL/SQL - describe

In article <35c987f7.85597308_at_news.u-net.com>,   russ_at_u-net.net (Russell Fray) wrote:
>
> Hi,
>
> When using oracle web application server and pl/sql, I am able to
> produce a display by using something along the lines of :
>
> select cust_num || surname || address from ows.table;
>
> However, where I substitute this to :
>
> describe ows.table;
>
> The program refuses to run.
>
> Is there an alternative which will give me a list of the field names
> and their datatypes other than describe? Ie,

There most cetainly is: select coumn_name from user_tab_columns

where table name = 'THE_TABLE_NAME_IN_CAPS_OVER_HERE'.

Best of all you don't need cookies :-)

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Aug 06 1998 - 08:39:52 CDT