Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: geting Table definition ?

Re: geting Table definition ?

From: nighthawk <nighthawk_at_mgfairfax.rr.com>
Date: Fri, 25 Feb 2000 13:24:28 GMT
Message-ID: <govt4.22839$gW5.115742@typhoon.southeast.rr.com>


select name from sys.col$ where obj# in (select obj# from sys.obj$ where name = 'NAME' and type = 2)

Christoph Skladal <c.skladal_at_kba.at> wrote in message news:895quh$64h$1_at_news.netway.at...
> Hello,
>
> can I get the list of the fields from a table with SQL-Command ?
>
> Thanks
>
> regards
>
> Christoph Skladal
>
>
Received on Fri Feb 25 2000 - 07:24:28 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US