Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: DESCRIBE?
You're absolutely right - what I should have written (passim) was
'my_table'.
Tx, GStC.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of David Sharples
Sent: Monday, March 28, 2005 3:44 PM
To: oracle-l_at_freelists.org
Subject: Re: DESCRIBE?
but that is a table you are describing - not a database
On Mon, 28 Mar 2005 12:41:02 -0800, Graeme St. Clair
<Graeme.St.Clair_at_hds.com> wrote:
> And it turns out that what I really wanted was:-
>
> Select * from user_tab_columns where table_name = 'my_data_base'
>
> Rgds, GStC.
>
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Mon Mar 28 2005 - 15:52:09 CST