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

Home -> Community -> Usenet -> c.d.o.tools -> Re: How to get a list of all the tables?

Re: How to get a list of all the tables?

From: j_beverly <j_beverly_at_yahoo.com>
Date: Mon, 12 Feb 2001 02:47:26 GMT
Message-ID: <3a874e86.4670767@news.erols.com>

select table_name from dba_tables;

On Mon, 12 Feb 2001 02:07:24 GMT, Babylon5Fan <alweiner_at_my-deja.com> wrote:

>I know you can use the sql stmt: describe table
>where table is the name of a table in the tablespace. However, is there
>a sql stmt to give a list of all the tables?
>
>
>Sent via Deja.com
>http://www.deja.com/
Received on Sun Feb 11 2001 - 20:47:26 CST

Original text of this message

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