Analyze object search results

After the search completes, the results appear in the search results grid. The grid displays the following parameters:

  • Name – The name of the database object that contains the search value.
  • Owner – The owner of the database object.
  • Schema – The schema to which the object belongs.
  • Database – The database that contains the object.
  • Object Type – The type of the database object.
  • Found In – The object name or body where the search value was found.

Search results grid

When you select a result in the grid, SQL Editor displays the DDL statements that define the selected database object.

SQL Editor DDL statement