Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: real oracle beginner
You are probably only after the tables of the db user you are logged in as.
try
select table_name from tabs;
from an sqlplus prompt.
hth
christof
davros 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 Mon Apr 08 2002 - 06:57:36 CDT