To use the search functionality in SQL Worksheet

Note

This section is not applicable for MySQL database services.

This topic describes how to search using the Omnisearch bar in SQL Worksheet.

Open the navigation menu and click Developer Services.
In the Database Tools section, click SQL Worksheet. You can also access SQL Worksheet from the Connection Details page of a specific database connection.
On the SQL Worksheet page, use the Connection menu to select a database connection. Optionally, click the Change Compartment link to select a database connection in a different compartment. If there are no connections available, you can select the Create Connection option in the Connection menu to create a database connection. See Using the Oracle Cloud Infrastructure Console for more information.
In the left sidebar, click Search.
The Search pane appears.
In the Search field, enter ALL to search across all object types. To search in a specific category or object type such as tables, enter Tables.
You see ALL added to the Search field.
After entering the category, enter the search term.
The results are displayed below and are organized by object type. For an understanding of how the search results are determined, see Using the Omnisearch Bar.