Query for All Tables and Fields in an Oracle Db [duplicate]

Question

I am using an Oracle DB with which I'm not familiar.

I would like to export something like a matrix of all tables and fields. Is this possible? Thanks.

Export a diagram from a utiity? <stackoverflow.com/a/12101819/1504882> — Elias
– Elias, Commented Jul 29, 2013 at 19:13
What do you say with matrix? Do you want a sql query or something else (diagram,etc)? — Gaston Flores
– Gaston Flores, Commented Jul 29, 2013 at 19:24

Robert · Accepted Answer · 2013-07-29 19:13:26Z

8

Try to use a system table ALL_TAB_COLUMNS

SELECT table_name, column_name 
FROM ALL_TAB_COLUMNS

answered Jul 29, 2013 at 19:06

Robert

25.8k8 gold badges70 silver badges86 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sebas · Accepted Answer · 2013-07-29 19:03:04Z

2

SELECT * FROM all_tables;
SELECT * fROM all_tab_columns;

answered Jul 29, 2013 at 19:03

Sebas

21.6k9 gold badges60 silver badges109 bronze badges