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: view tables

Re: view tables

From: Thorsten Kitz <kitz_at_opitz-partner.de>
Date: Thu, 2 Jul 1998 11:21:26 +0200
Message-ID: <6nfj7r$355$1@news.nacamar.de>


Hey,

Cyril Matalon schrieb in Nachricht <359B4264.331A_at_jouy.inra.fr>...
>I would like to know how I can see the names of the tables in a data
>base with a sql command.

select * from tab;

or

select table_name from user_tables;

Bye,

Thorsten. Received on Thu Jul 02 1998 - 04:21:26 CDT

Original text of this message

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