Re: All tables

Madhivanan wrote:
> >From SQL Plus,
>
> How can I know which database it is currently?
> What is the query to find all the tables in the database?
>
> Madhivanan

• SQL> show parameter db_name
• SQL> select name from v$database;
• SQL> select * from all_tables;

This ofcourse is all documented.

Regards
/Rauf Received on Fri May 06 2005 - 07:07:52 CDT