command to list tables in the database?

[Wildlander]

I am runnint SQL Plus and am looking for a command to list the tables in the database?

-K

 

[crufty]

From within SQL Plus try:

select * from tab;

 

[karluk]

You should query the catalog view, dba_tables, if you have permission to do so. Something like

select owner, table_name from dba_tables;

If you don't have authority to select from dba_tables, you should try all_tables. That will give you a list of the tables in the database, regardless of owner, but restricted to the ones that you have authority to see.

select owner, table_name from all_tables;