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: Christof Kaiser <Kaiser_at_logiball.de>
Date: Mon, 08 Apr 2002 13:57:36 +0200
Message-ID: <3CB185B0.2007F131@logiball.de>


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

Original text of this message

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