Re: All tables

From: Cris Carampa <cris119_at_operamail.com>
Date: Fri, 06 May 2005 14:10:21 +0200
Message-ID: <427b5ec4$0$20674$5fc30a8@news.tiscali.it>

Madhivanan wrote:

> How can I know which database it is currently?

select global_name from global_name;

> What is the query to find all the tables in the database?

SELECT * FROM DBA_TABLES, providing you have the right priviledges to do so.

Kind regards,

-- 
Cris Carampa (cris119_at_operamail.com)
E' faticoso frequentare i bambini.
Essere obbligati a innalzarsi fino all'altezza dei loro sentimenti.
Tirarsi, allungarsi, alzarsi sulla punta dei piedi. (Janusz Korczak)

Received on Fri May 06 2005 - 07:10:21 CDT