Re: PL/SQL - describe

From: <jtesta_at_my-dejanews.com>
Date: Thu, 06 Aug 1998 13:02:10 GMT
Message-ID: <6qc9gi$ctp$1@nnrp1.dejanews.com>

how about select column_name, data_type from sys.user_tab_columns where table_name = 'TABLE_NAME';

PS: there is alot more than those 2 column in the view sys.user_tab_columns

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,
>
> select * from sys.something where tablname = ows.table
>
> Please cc replies to russ_at_u-net.net if possible.
>
> Thanks,
> Russell.
>
>

-----== 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:02:10 CDT