Re: real oracle beginner

Hi dav,
If you are dba or have dba privs then
select table_name from sys.dba_tables will show them all to you ( including sys and system tables)

Otherwise

select table_name from user_tables ( shows tables you created)

select table_name from all_tables ( shows tables you have privs on)

You can also look as sys.dba_objects ( user_objects, all_objects) to see what other things ( tables,views, etc) are in there..
Do a desc on those to see what they contain...

davros <dav.1_at_bigfoot.com> wrote:

>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 - 09:40:49 CST