View original (French)

List of tables in an Oracle database

cainmaro -  
 nida -
Hello everyone!

I am looking for a way to retrieve:
- The list of tables created from the name of the database,
- The list of columns from a given table.

I would like to do this if possible in the form of SQL queries and under Oracle...

Thank you in advance for the help you will provide me...

Best regards,

cainmaro

2 réponses

Réponse 1 / 2
koukaratcha
 
For the columns: type "desc;"
For the list of tables: select table_name from all_tables; (I'm not quite sure about that one)
1
DidGeo
 
For the list of tables in a schema, try instead
select table_name from user_tables
0