Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: real oracle beginner
You should install the oracle client. Then use dba studio.
The sql to use to know what tables are in the db is 'select * from tabs;'
To get a description : 'desc tablename'
hth
Jerome
"davros" <dav.1_at_bigfoot.com> a écrit dans le message de 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:01:08 CST
![]() |
![]() |