Re: real oracle beginner

From: Nick P <nick_pope_at_nospamhotmail.com>
Date: Fri, 5 Apr 2002 11:08:17 +0100
Message-ID: <uaqtqtsm0doj50@corp.supernews.com>

Use the query:

select table_name, owner
from dba_tables

the user_??? and dba_??? objects are very useful. It is worth finding your way around them.

Immediate ones that might be of use are:-

dba_tables
dba_indexes
dba_ind_columns

Don't forget DESCRIBE <tablename> is very useful

e.g.

DESC MY_TABLE will give the structure of the table MY_TABLE

Nick

"davros" <dav.1_at_bigfoot.com> wrote in message news:3CAD6E0E.6060306_at_bigfoot.com...
> sorry for such a lame question but i know my way around sql but have
> never used oracle before
>
> how do i see what tables are in the current db i am in ?
>
> i have worked out that "describe Table_name" will tell table details but
> i dont know what the tables are called
>
> thanks
>
> dav....
>
Received on Fri Apr 05 2002 - 04:08:17 CST