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. Click the Search icon on the left to display the Find Database Object window, where you can specify a connection name and search criteria. To display all criteria, click More. (For a connection to an Oracle Database Release 11.1 or later connection, clicking More causes SQL Developer to use PL/Scope, which enables you to search for the usage, for example, for the variable declarations.)
The following figure shows part of the Find Database Objects pane with results from a search for column definitions associated with a connection named hr_system05
where the column name starts with EM
.
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
.
Type: Type of object for which to restrict the search.
Usage: Usage of the object. May or may not be relevant, depending on the type of object.
Click the Lookup 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.
You can detach, move, and dock the Find Database Objects pane by clicking and holding the tab, and dragging and positioning the pane.
Related Topics