Data Dictionary Views
Oracle provides a rich set of data dictionary views. These views are owned by the user “SYS” and can be accessed by suitably privileged users. Views that begin with USER_ do not include an OWNER column, since they describe only the objects owned by the currently logged in user.
To get a list of these views, from the database, and the comments associated with them, log on to SQL*Plus as sysdba (internal) and then execute the following package to install it:
CREATE OR REPLACE PACKAGE describe IS PROCEDURE describe_tables( tab_owner VARCHAR2, names_like VARCHAR2 ); END describe; / CREATE OR REPLACE PACKAGE BODY describe IS PROCEDURE print_preamble IS BEGIN dbms_output.put_line( '<HTML>' ); dbms_output.put_line( '<HEAD>' ); ...
Get Oracle® DBA SQL Quick Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
