Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: real oracle beginner

Re: real oracle beginner

From: Jerome Baton <jbaton_at_oxymel.com>
Date: Fri, 5 Apr 2002 12:01:08 +0200
Message-ID: <3cad7677$0$11099$626a54ce@news.free.fr>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US