Re: getting result like in desc some_table with select?

From: Douglas Hawthorne <douglashawthorne_at_yahoo.com.au>
Date: Thu, 18 Mar 2004 23:44:23 GMT
Message-ID: <rvq6c.110033$Wa.20166@news-server.bigpond.net.au>

"rowla" <rowla.WYTNIJ.TO_at_I.TO.pl> wrote in message news:c3dall$20q$1_at_sunflower.man.poznan.pl...
> I wonder if there's a way to get a similar result to desc some_table;
> I need column names and types of them.
> I must use selects
>
> thx in advance for any help
>
> --
> best regards
> jacek

Jacek,

Please look at the USER_TAB_COLUMNS and USER_CONSTRAINTS views. Further information can be found in the Database Reference manual.

Douglas Hawthorne Received on Thu Mar 18 2004 - 17:44:23 CST

This message: [ Message body ]
Next message: John Oracle DBA: "Re: Long wait times for db file sequential read"
Previous message: rowla: "getting result like in desc some_table with select?"
In reply to: rowla: "getting result like in desc some_table with select?"
Next in thread: rowla: "Re: getting result like in desc some_table with select?"
Reply: rowla: "Re: getting result like in desc some_table with select?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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