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 answers

  1. 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
    1. DidGeo
       
      For the list of tables in a schema, try instead
      select table_name from user_tables
      0