SQL query to pull all database table structure in one go?

Question

I know this SQL query provides the table structure:

DESC TableName; 

But do we have a query which will provide table structure of all database tables in one go/single query/command? BTW, I am using SQL Developer.

Thank you in advance.

Answer 1

The answer can be found here. You can query

SELECT * FROM ALL_TAB_COLUMNS

or

SELECT * FROM ALL_TAB_COLS

Difference between ALL_TAB_COLUMNS and ALL_TAB_COLS