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

Home -> Community -> Usenet -> c.d.o.server -> Re: Database names?

Re: Database names?

From: Richard Ward <Richard_at_ctcal.ctech.ac.za>
Date: Wed, 19 Feb 2003 12:56:50 +0200
Message-ID: <b2vntc$2dbm$1@news.adamastor.ac.za>


For Oracle 7.3.4 (heh) probably will work on all versions though. try:
select table_name from all_tables;

Should give you a list of all the tables in the DB. do also:
desc all_tables;
and modify the first select to suit.

Hope this is what you're looking for.

Cheers
Richard Received on Wed Feb 19 2003 - 04:56:50 CST

Original text of this message

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