Oracle database object search

The Find Object functionality can help you search through object names, object DDLs, and table data. The main principles of searching in Oracle are described below.

Utilities that search through Oracle database objects (tables, columns, declarations within functions, or procedures) are often positioned as separate products that you should install and keep up to date. Still, searching through database objects remains a task important enough for you to spend time on deciding which tool to use. With dbForge Studio for Oracle, you can get this functionality along with other useful database management features. You can search through objects in the following cases:

  • finding any Oracle object (such as a table) in the Database Explorer tree by its name or part of its name;
  • reducing the number of errors and improving database performance.
  • renaming database objects without breaking dependencies;

Search in object names

You can benefit from this option in cases when you need to find instances of the search phrase in the names of database or schema Oracle objects. Type the search phrase in the corresponding field, select the connection and schema(s), enable the checkboxes near required objects, adjust the search options, and start searching.

The application will send a query to the metadata, find the ?Name? column there, and search for instances of the specified phrase. The results will be displayed in the Find Object Results window. From this window, you can start working with found objects.

Search object names

Search in object DDLs

In this case, the application will search the specified phrase in DDLs of all objects.

To do this, it will obtain DDLs of all schema objects and search for instances of the requested phrase in the text. The search results will contain the object name, its owner, and the line at which the match was found.

Search object DDL

Search in table data

When you have to find an instance of the search phrase in the data of database tables, this is the right option to use.

The application will send a query to obtain data from all columns in your Oracle database tables, and then search for a matching string, table name, or column name.

In the Object name filter field, you can specify names of tables, views or materialized views to narrow down the search.

Search table data

Working with search results

Search results are displayed in the Find Object Results window. From this window, you can navigate to an object in the Database Explorer, open it, generate schema scripts, clear results, etc.

All these options accelerate your work and make routine tasks easier to accomplish. Besides, the chance of making mistakes is really low as everything is displayed in one window and you can navigate between different objects automatically.

Work with search results

Conclusion

dbForge Studio for Oracle has robust built-in capabilities for searching through Oracle databases. You can search for instances of the specified phrase in object names, object DDLs, and table data. You can then navigate through search results and work with them in various ways. All this functionality is provided by default in dbForge Studio for Oracle along with many other database management tools and features, for example Visual editors for database objects in Oracle.

dbForge Studio for Oracle

Multifunctional Oracle GUI

Download

Availability in the editions of dbForge Studio for Oracle

Feature

Enterprise
Professional
Standard
Express
Database search (objects and data)
Yes
Yes
Yes
None