O'Reilly logo

Oracle® DBA SQL Quick Reference by Robert Cordingley, Charlie Russel

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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>' ); ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required