command to show all the tables in oracle

Hi all,
what is the command to show all the tables i created before in oracle.

thanks

 

show tables;

 

It seems only to work in MYSQL.
I try servral time "show tables", but error message appears as follow:
" SP2-0158: unknown SHOW option "tables"

 

Hmmm, then try:

select * from tabs;

 

try select * from cat ;

 

A similar thread found via Google.

 

This is the command to show tables in Oracle database:
select * from user_objects
where object_type ='TABLE';

if you do a desc on the user_objects table you will see the fields (columns) you may want to eliminate to get a cleaner result. see the results below:
SQL> desc user_objects;
Name Null? Type
----------------------------------------- -------- ----------------

OBJECT_NAME VARCHAR2(128)
SUBOBJECT_NAME VARCHAR2(30)
OBJECT_ID NUMBER
DATA_OBJECT_ID NUMBER
OBJECT_TYPE VARCHAR2(19)
CREATED DATE
LAST_DDL_TIME DATE
TIMESTAMP VARCHAR2(19)
STATUS VARCHAR2(7)
TEMPORARY VARCHAR2(1)
GENERATED VARCHAR2(1)
SECONDARY VARCHAR2(1)
NAMESPACE NUMBER
EDITION_NAME VARCHAR2(30)

SQL>

 

You can use select * from tab to see all tables in oracle, hope it helps you

 

try this


SELECT * FROM cat;
COL table_name FORMAT a30; COL table_type FORMAT a30;
SELECT * FROM cat;