Query for All Tables and Fields in an Oracle Db

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.

What do you say with **matrix**? Do you want a sql query or something else (diagram,etc)? — Gaston Flores, Jul 29 '13 at 19:24

Robert · Accepted Answer · 2013-07-29T19:13:26.220

8

Try to use a system table ALL_TAB_COLUMNS

SELECT table_name, column_name 
FROM ALL_TAB_COLUMNS

edited Jul 29 '13 at 19:13

answered Jul 29 '13 at 19:06

Robert

score 2 · Answer 2 · answered Jul 29 '13 at 19:03

2

SELECT * FROM all_tables;
SELECT * fROM all_tab_columns;

answered Jul 29 '13 at 19:03

Sebas

2 Answers2