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;
Search This Blog
Total Pageviews
Monday, 19 September 2011
Subscribe to:
Post Comments (Atom)
Oracle DBA
anuj blog Archive
- ▼ 2011 (362)
No comments:
Post a Comment