How to show all tables in DB?

[BEJW]

Hi,

I want to know how to show all table names in DB using SQL?

Thanks a lot.
Jeannie

 

[AOLEURO]

Hi

connect as SYSDBA and

select table_name, owner from dba_tables;
Regards
Allan
Icq: 346225948
! If you can't prove it - don't bother try to teach me !

 

[BEJW]

Thanks.AOLEURO I got them.

Jeannie