Oracle

[Anon]

Hi

Anybody knows what is the command in SQL (ORACLE) to list all databses within a server and all tables within a database?

OOzy

[Anon]

All Tables

Select * from all_tables;

(ALL_TABLES is a VIEW )

Select * from all_views where
view_name='ALL_TABLES';

All Databases

If you don't have database links
you don't see the other DATABASES.