Oracle Dictionary - Dynamic Views

Oracle dict view

col TABLE_NAME format a40
col COMMENTS format a70
SELECT * FROM DICT WHERE TABLE_NAME LIKE 'V$%' ORDER BY TABLE_NAME ;


col TABLE_NAME format a40
col COMMENTS format a70
SELECT * FROM DICT WHERE TABLE_NAME LIKE 'USER_%' ORDER BY TABLE_NAME;


col TABLE_NAME format a40
col COMMENTS format a70
SELECT * FROM DICT WHERE TABLE_NAME LIKE 'ALL_%' ORDER BY TABLE_NAME;


col TABLE_NAME format a40
col COMMENTS format a70
SELECT * FROM DICT WHERE TABLE_NAME LIKE 'DBA_%' ORDER BY TABLE_NAME;