Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Database names?
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