Databases Reference
In-Depth Information
Figure 13-10.
Find icon
Clicking the Find icon opens a pop-up window that contains interactive reports for the following object types:
•
Application and page items
•
Pages
•
SQL queries from report regions
•
Database tables in the parsing schema
•
PL/SQL packages, functions, and procedures in the parsing schema
•
Images, including standard images, workspace images, and application images
•
A list of debug log entries
•
Application items, page items, and collections in the current session
•
A list of errors that have occurred in this application at both the region and page level
The APEX finder is helpful because it allows you to quickly search for something while you're in the Application
Builder and doesn't require you to leave the page. If you need to do more complex searches or filters, we recommend
querying the APEX views.
Search Application
The APEX views GUI, queries against the APEX views, and the APEX finder are good tools if you know exactly what
you're searching for in an object type. For example, if you want to see whether a particular table was referenced
in a query, then you can search the APEX_APPLICATION_PAGE_REGIONS view for the table name in the
REGION_SOURCE column.
What if you want to search an entire application to see whether it references a specific table? Suppose, for
example, that you rename the
TICKETS
table to
ISSUES
. How can you easily search your entire application for any
reference to
TICKETS
? The answer is to use a new feature added in APEX 4 called Search Application, which searches
through the entire application.
To search the entire application, enter your search criteria in the Search Application field (located in the
upper-right corner—see Figure
13-10
). Figure
13-11
shows the detailed results of all occurrences of
TICKETS
in the
application. For each result, a link is provided to the exact location of the result. Using the Search Application feature,
you can easily find all references to the
TICKETS
table and replace them with
ISSUES
.
