O'Reilly logo

Advanced Oracle PL/SQL Developer's Guide - Second Edition by Saurabh K. Gupta

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

Tracking PL/SQL coding information

The Oracle-supplied dictionary views are a great source of information for performing drill-down analysis of PL/SQL code. Although there are several dictionaries that store PL/SQL object information, the important ones are USER_ARGUMENTS, USER_OBJECTS, USER_SOURCE, USER_PROCEDURES, and USER_DEPENDENCIES. These views also have their ALL_* and DBA_* counterparts. For your reference, the USER, ALL, and DBA category views are described as follows:

  • USER: Contains only the objects that are owned by a user
  • ALL: Contains the objects that can be accessed by a user
  • DBA: Contains all the objects accessible by the SYS user or a user with DBA privileges

You can query the data dictionary views from the DICTIONARY view and their ...

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