How do I list all the available tables in a database?

[Guest_imported]

Hi, how do I list all available tables in a database in the SQLPlus?
Thanks in advance.
Felipe
fsolanet@magpage.com

 

[MikeLeung]

Assuming you are talking about user tables not system tables. The following SQL should list out all the tables for you:

select table_name from user_tables;

Mike

 

[lamija]

You can use:

select *
from tab;

select *
from tabs;

 

[LokiDba]

The above list all tables in the current schema that you are logged on to. If you want all tables that exist on the database server then you need to do the following:

SELECT owner,
table_name
FROM all_tables
WHERE OWNER <> 'SYS' AND
OWNER <> 'SYSTEM'

This will list all database tables on the database server except the system ones in SYS and SYSTEM.

Hope of some use

LokiDBA