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 using the User Selector and Filter Selector. You can easily switch between these users and filters with a dropdown list. In the screenshot to the left you can see that objects for the current user are displayed, and that a filter called "All objects" is used, which does not filter out any objects. You can define your own filters to further customize the Object Browser. Furthermore you can enter a filter text to quickly find a specific object or a selection of objects.

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.