Query for all tables and columns in a database in one statement

Question

How would you query an oracle sql database for all tables in the database and the columns associated with them in with single line/statement of code?

Format:

Table1
  colums
Table2
  Colums

I believe this answer extensively explains how to do this. http://stackoverflow.com/questions/205736/get-list-of-all-tables-in-oracle — Dacotah, Dec 02 '14 at 17:53
possible duplicate of [List table and columns in one statement](http://stackoverflow.com/questions/27282063/list-table-and-columns-in-one-statement) — abhi, Dec 03 '14 at 21:51

score 0 · Answer 1 · answered Dec 03 '14 at 09:28

0

select * from all_tab_columns

In this query you see all columns in your table

answered Dec 03 '14 at 09:28

starko

1 Answers1