Previous Next JavaScript must be enabled to correctly display this content

## 5.18 Using the Find Icon

Click the Find icon to search for items, pages, queries, tables, PL/SQL code, view debug reports, view session state, and view errors.

The Find icon resembles a flashlight and displays on many pages in App Builder including the Application home page, Shared Components, and the Edit Application Definition.

- Locating the Find Icon
  Learn about the Find Icon.
- Searching for Items
  Search for items using the Item Finder.
- Searching for Pages
  Search for pages using the Page Finder.
- Searching for Queries
  Search for queries using the Query Finder.
- Searching for Tables
  Search for tables using the Table Finder.
- Using the PL/SQL Finder
  Locate and view details about stored procedures, functions, and packages using the Procedure Finder.
- Viewing Application Errors
  View a report of application errors.

Parent topic: Creating Applications

### 5.18.1 Locating the Find Icon

Learn about the Find Icon.

To use the Find icon:

1. Click the Find icon.
   Description of the illustration find_icon.png

   The Items Finder appears.

   Description of the illustration find_icon2.png
2. Click one of the following tabs:
   - Items - See Searching for Items.
   - Pages - See Searching for Pages.
   - Queries - See Searching for Queries.
   - Tables - See Searching for Tables.
   - PL/SQL - See Using the PL/SQL Finder.
   - Debug - See Viewing Debug Messages for an Application.
   - Session - See Viewing Session State
   - Errors - See Viewing Application Errors.

Parent topic: Using the Find Icon

### 5.18.2 Searching for Items

Search for items using the Item Finder.

In App Builder, an item can be a text field, text area, password, select list, checkbox, and so on. You can use the Item Finder to search for items within the current application or within the schema associated with the workspace.

To search for items:

1. Click the Find icon.

   The Items Finder appears.

   A navigation bar displays in the center the page (see previous illustration) and contains the following controls:

   - Select columns to search - Resembles a magnifying glass. Click this icon to narrow your search to specific columns. To search all columns, select All Columns.
   - Text area - Enter case insensitive search criteria (wildcard characters are implied) and click Go.
   - Go button - Executes a search.
   - Actions menu - Clicking the icon displays the Actions menu. Use this menu to customize the display.
2. To edit a specific item, navigate to the appropriate item.

See Also:

Understanding Page Items

Parent topic: Using the Find Icon

### 5.18.3 Searching for Pages

Search for pages using the Page Finder.

A page is the basic building block of an application. You can use the Pages Finder to search for pages within the current application or within the schema associated with the workspace.

To search for a page:

1. Click the Find icon.
2. Click the Pages tab.

   The Pages Finder appears. A search bar displays at the top of the page.

3. To link to the Items page, click the page number.

Parent topic: Using the Find Icon

### 5.18.4 Searching for Queries

Search for queries using the Query Finder.

You can use the Queries Finder to locate a query within your application or within the schema associated with the workspace.

To search for a query using the Queries Finder:

1. Click the Find icon.
2. Click the Queries tab.
   The Queries Finder appears. A search bar displays at the top of the page.
3. To link to the Items page, click the page number.

Parent topic: Using the Find Icon

### 5.18.5 Searching for Tables

Search for tables using the Table Finder.

You can use the Tables Finder to view tables within the schema associated with the workspace.

To view tables associated within the current schema:

1. Click the Find icon.
2. Click the Tables tab.
   The Tables Finder appears. A search bar displays at the top of the page.
3. Select a table name.

   A table definition appears.

   This report displays the column names, data type, length, precision, and scale and the SQL necessary to re-create the table appears at the bottom of the page.

See Also:

Managing Tables in Oracle APEX SQL Workshop Guide

Parent topic: Using the Find Icon

### 5.18.6 Using the PL/SQL Finder

Locate and view details about stored procedures, functions, and packages using the Procedure Finder.

You can use the Procedure Finder to locate and view details about stored procedures, functions, and packages associated with each object within the schema associated with the workspace.

To search for PL/SQL code in the current schema:

1. Click the Find icon.
2. Click the PL/SQL tab.

   The PL/SQL Finder appears. A search bar displays at the top of the page.

3. To view additional details, select the procedure, function, or package name.

   The procedure, package, or function name appears and additional information including the owner, source name, source type, return type, argument names, data types, and IN/OUT parameters.

See Also:

Managing Database Objects with Object Browser in Oracle APEX SQL Workshop Guide

Parent topic: Using the Find Icon

### 5.18.7 Viewing Application Errors

View a report of application errors.

To view a report of application errors:

1. Click the Find icon.
2. Click the Errors tab.
   The Application Errors report appears.

Parent topic: Using the Find Icon