Listing table Names from SQL

[wuxapian]

I know this is more of an SQL problem but can anyone tell me how to display a list of tables in the current or a specified database (using SQL).

TIA
Wuxapian...

 

[lewisp]

select table_name,owner from all_tables;

or

select table_name from user_tables; for your own.

 

[spenglerr]

A good way is to use
select * from tab
This is not so overcrowded with informations if you only need the names of tables and views.