Home > SQL Developer Concepts and ... > Finding Database Objects
You can find various types of objects (tables, columns, declarations within functions or procedures, and so on) associated with an Oracle database connection, and open editing panes to work with those objects. To open the Find Database Object pane, right-click a connection name in the Connections navigator and select Find DB Object. You can also click View, then Find DB Object.
Select the desired database connection, the types of objects for which to search, and a search string. The following figure shows Find Database Objects pane with results from a search for all objects associated with a connection named hr_system05
where the object name starts with EM
.
In this example, the search finds nine objects across four object types. In the display of results, you can click any of the object names to bring up the object in an appropriate editor.
Connection: Database connection to use for the search.
Name: An object name or a string containing one or more wildcard characters. For example: EM%
for all names starting with EM
.
All Schemas: Select one or more schemas, or all schemas, in which to perform the search. In this example, the blue solid square reflects the fact that the schema you selected is the schema to search; however, you click to select all schemas, or you can expand All Schemas and individually select schemas.
Types: Type of object for which to restrict the search. You can search all columns, or all or individual identifier types, identifier usages, and source lines.
Click the Go icon to display objects that meet the specified criteria. To view or edit one of the objects (or the parent object that contains the specified object), double-click or right-click its name in the results display.
Related Topics