2.4 Developer Navigation Tools

Developer Navigation tools display in the header region on many Oracle APEX pages, including the Workspace home page, App Builder home page, the Application home page, Page Designer, and Shared Components.

2.4.1 Global Search

The Global Search field (also known as Spotlight Search) displays in the header region and provides an effective way to navigate App Builder.

Key features of Global Search include:

  • Offers effortless navigation within a workspace enabling you to quickly find applications, pages, Shared Components, APEX menus, and so on.

  • Search for component names and immediately set focus to those items in Page Designer.

  • Provides a unified search experience throughout APEX.

About Using Global Search

You can activate Global Search in two ways:

  • Click the Global Search field in the in the header region

  • Use the keyboard shortcut (Ctrl + Quote) (') (US Keyboards only)

Use Global Search to search all applications in the workspace no matter what your location in the current workspace. For example, if your workspace contains the Sample Reporting sample app, entering Sample will find it. Similarly, you can access global navigation menus that appear at the top window adjacent to the Oracle logo. For example, enter SQL Commands in the Global Search field to instant access SQL Commands.

To close the Global Search dialog, press the Esc key, or click anywhere outside the results.

Syntax to Navigate to a Page or Search for a Regular Expression

Within App Builder and on the Application home page, use the following syntax to navigate to a specific page or search for a regular expression:



  • application_ID is the numeric identification number (or ID) that identifies an application.

  • page_ID is the numeric identification number that identifies a specific page.

  • regexp: is literal text.

  • expression is a regular expression to search for.

The following example navigates you to page 10 of application 570:


You can also use this syntax to navigate to the Shared Components page of a given application:



  • application_ID is the numeric identification number (or ID) that identifies an application.

The following example demonstrates how to navigate to the Shared Components page of application 570:


About Navigating Search Results

Global Search results display in a dialog. Use the Up and Down arrows keys to navigate the results and press Enter to make a selection. Since the the Global Search icon displays on nearly every page in APEX, you can continue to narrow your search until you find the app, page, or component (such as the item, button, or region) which contains the keyword.

Other available shortcuts change depending on where you are in App Builder, for example:

  • In Page Designer - To search for a page, press Ctrl + 4.

  • In App - To search within an application, press Ctrl + 3.

  • All Apps - To search all applications, press Ctrl + 2.

  • Current Workspace - To search a workspace, press Ctrl + 1.


Some browsers map these Ctrl key shortcuts for quick tab navigation. In that case, the shortcut does not work as described above. Instead, they simply activate a particular open browser tab.

Example 2-1 Search Example

Suppose you need to find an application called Employees which includes interactive grid built on the EMP table.

  1. Find the application.

    1. On the Workspace home page, click the Global Search field and enter emp.

      Global Search would return the results:

      • Employees (App)

      • Templates

      • Create Email Template

      • Search all applications for emp (Ctrl + 2)

      • Search Workspace for emp (Ctrl + 1)


      Templates and Create Email Template appear because they contain the text string emp.
    2. Select Employees to view that application.

      The Employees application appears.

  2. Search the application.

    1. On the Application home page, click the Global Search field and enter EMP.

      Global Search returns the results that include numerous pages and other items.

    2. Select the option the includes a page reference.

      The page appears in Page Designer.

  3. Search the page.

    1. In Page Designer, find the Global Search field and enter EMP again.

      Global Search returns the results that include numerous components.

    2. Select a component (such as a process, column, region, and so on).

2.4.2 Administration Menu

The Administration menu displays to the right of the Global Search field and features an outline person with a wrench.

Clicking the Administration menu displays the following options:

  • Administration links to the Workspace Administration page. To access the Oracle APEX development environment, users sign in to a shared work area called a workspace. Workspace administrators monitor and administer a workspace. Common workspace administration tasks include managing service requests, configuring workspace preferences, creating workspace announcements, managing session state, creating user accounts, and managing groups.

  • Manage Service displays a submenu of options on the Manage Service page. Administrators use the Manage Service page to manage service requests, configure workspace preferences, edit workspace announcements, and view workspace utilization reports.

  • Manage Users and Groups links to Manage Users and Groups page. Workspace administrators can create new user accounts, manage existing user accounts, and change user passwords.

  • Monitory Activity links to the Monitor Activity page. Use this page to monitor changes to page views, developer activity, page view analysis, and active sessions. It also shows reports on such information as login attempts and external click counts.

  • Dashboards links to the Dashboard page. Use this page to view details about the current workspace and monitor users, activity, developer activity, performance, application development, and view database details.

  • Change My Password links to the Change Password section of the Edit Profile dialog box.

See Also:

2.4.3 Help Menu

The Help menu features a question mark enclosed with a circle.

Click the Help menu to access the following menu items:

  • Documentation links to Oracle APEX, Oracle Help Center.

  • Discussion Forum links to the Categories page where you can access APEX Discussions.

  • Learn More about Oracle APEX links to the Oracle APEX page.

  • About. Links to the About APEX dialog. This dialog includes information about the APEX instance and the database version.

2.4.4 Account Menu

The Account menu displays in the upper right corner of the page. You open the Account menu can be opened by clicking on the User icon in the header.

Click the Account menu to view your username, current workspace, and user role. If Single Sign On (SSO) is enabled, the link Change Workspace also appears. Key controls on this menu include:

  • Edit Profile. Click Edit Profile to edit your first and last name, upload or choose a photo image, alter your email address (if SSO is not enabled), and reset your password.


    If you are using Single Sign-on authentication, Change Workspace also displays. Click Change Workspace to view a list of workspaces you have access to.

  • Appearance. Configure the Appearance switch to determine how the Oracle APEX user interface displays. Options include:
    • Automatic (default) detects the appropriate setting based on existing system or browser settings.
    • Light Mode renders the user interface using dark-colored text, icons, and graphical user interface elements on a lighter background.
    • Dark Mode renders the user interface using light-colored text, icons, and graphical user interface elements on a darker background.
  • Preferences. Click Preferences to change your default schema, default date format, configure whether SQL Workshop CSV downloads are in Unicode, and control how windows display when App Builder runs applications.
  • Sign Out. Click Sign Out to log out of the current workspace.