Re: geting Table definition ?

From: GHouck <hksys_at_teleport.com>
Date: Fri, 25 Feb 2000 05:05:20 -0800
Message-ID: <38B67E10.62F2@teleport.com>

Christoph Skladal wrote:
>
> Hello,
>
> can I get the list of the fields from a table with SQL-Command ?
>
> Thanks
>
> regards
>
> Christoph Skladal

First choice:
Download TOAD (Tool for Oracle Application Developers) at http://www.toadsoft.com (there is a free version).

Second choice:
something like the following can work, although I don't know if it is the best method:

select * from user_tab_columns where table_name='...'

Yours,

Geoff Houck
systems hk
hksys_at_teleport.com
http://www.teleport.com/~hksys Received on Fri Feb 25 2000 - 07:05:20 CST