RE: DESCRIBE?

From: Graeme St. Clair <Graeme.St.Clair_at_hds.com>
Date: Mon, 28 Mar 2005 12:41:02 -0800
Message-ID: <5E927FAE154F7A4FB83E49E1139F137F06AAE8FD@ussccem04.hds.com>

And it turns out that what I really wanted was:-

Select * from user_tab_columns where table_name = 'my_data_base'

Rgds, GStC.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Graeme St. Clair
Sent: Monday, March 28, 2005 2:38 PM
To: oracle-l_at_freelists.org
Subject: RE: DESCRIBE?

Thanks to all responders, particularly Jonathan. The first para of his first citation is:-

QUOTE You've just taken on responsibility for a new database. New to you, that is
-- the database has actually been running for some years. What's the first
thing you want to do? If you're like me, you probably want to get a handle on just what it is that you have. What's in the database? How big is it? Who are the users and how many of them are there? The answers to all of these questions lie in the Oracle data dictionary.

UNQUOTE How truly deeply true...

Tx & rgds, GStC.
--

http://www.freelists.org/webpage/oracle-l Received on Mon Mar 28 2005 - 15:44:51 CST