Select * from user_tab_columns where table_name = 'my_data_base'
Rgds, GStC.
-- --Original Message-- -- From: oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)] On Behalf Of Graeme St. Clair Sent: Monday, March 28, 2005 2:38 PM To: oracle-l@(protected) 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.
