PL/SQL Developer - The Object Browser

  You can keep the Object Browser available at all times in PL/SQL Developer. It gives you access to all information that is relevant to PL/SQL development:
  • Create, duplicate, view, edit, rename and drop objects.
  • View properties and descriptions of functions, procedures, packages, types, triggers, java sources, tables, constraints, indexes, views, sequences, and so on.
  • View reference information: which objects are referenced by an object, and which objects does an object reference. You can also quickly compile all referencing objects that have become invalid.
  • Enable and disable triggers and constraints.
  • View user privileges, role privileges and synonyms for all objects.
  • Query and edit the data of tables and views.
  • Find objects by searching for text in the database source.

You can configure which objects are visible in the Object Browser by defining Browser Filters. You can easily switch between these filters with a dropdown list. In the screenshot to the left a filter called 'My objects' is used, which displays all objects that are owned by the current user.

You can also define your own folders and either add objects manually or define a query to populate the folder. Furthermore you can define the folder hierarchy, order and color. The 'Recent Objects' folder makes it easy to find objects you have recently used.

back