Re: PL/SQL - describe

Russell Fray wrote:

> ...
>
> 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
>

  Sure,

Try Select * From USER_TAB_COLUMNS Where TABLE_NAME = 'NAME';

Hope this help,
ADOLFO Received on Thu Aug 06 1998 - 06:30:49 CDT