O'Reilly logo

Oracle Advanced PL/SQL Developer Professional Guide by Saurabh 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

Using SQL Developer to find coding information

The object metadata information retrieved from the dictionary views is a conventional way to track code information. But these days, the IDE have been made self-sufficient to generate some vital predefined reports. The metadata information demonstrated in the last section using dictionary views can also be generated from SQL Developer. SQL Developer is a free UI based interactive IDE tool which boards multiple database utilities.

Here, we will demonstrate the tracking of code through SQL Developer:

  1. Go to View | Reports:
    Using SQL Developer to find coding information
  2. Go to All Reports | Data Dictionary Reports | PLSQL:
    • Under PLSQL, you find three options. ...

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