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: Newbie SQL question

Re: Newbie SQL question

From: Gerald Kilgus <gerald.kilgus_at_merck.de>
Date: Thu, 23 Sep 1999 16:08:18 +0200
Message-ID: <37EA3452.1F734BE8@merck.de>


Hi Mike,

try

select table_name from user_tables;

cheers
Gerald

michael_gressman_at_my-deja.com wrote:

> OK, I know that I can use DESC TableName to describe tables, but what if
> I don't know what the name of the table is? Is there an SQL query that
> will give me a list of the tables?
>
> Thanks,
> Mike
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Thu Sep 23 1999 - 09:08:18 CDT

Original text of this message

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