Database Reference
In-Depth Information
GUI as well as descriptions for each of the columns. The following query lists all the
APEX views:
SELECT *
FROM apex_dictionary
WHERE column_id = 0
There is a slight difference when querying the APEX views in SQL compared to the
GUI. When you use the developer GUI, only applications that reside in the workspace
appear in results. When you query through SQL, only applications whose parsing
schema is the same as your connection appear in results. If you connect as SYS,
SYSTEM, or a user who has been granted the APEX_ADMINISTRATOR_ROLE, you
can view all the applications regardless of the application's parsing schema.
In the previous section, the example described how to look at all the help text for
items with
PRODUCT_ID
in their name. You can view the same set of results by run-
ning the following query:
SELECT workspace,
application_id,
application_name,
page_id,
page_name,
item_name,
item_help_text
FROM apex_application_page_items
WHERE item_name LIKE '%PRODUCT_ID%'
Searching isn't the only use for the APEX views. You may also need to use the
APEX views when you're creating plug-ins or adding advanced features to an applica-
tion.
Searching in APEX
The previous section examined how to use the APEX views to search for items in your
application. In this section, you learn alternative ways to search through an application.
