APEX:创建页面时实际存储了什么

当你创建一个页面时，APEX 会记录以下信息：

页面类型
区域
项目
按钮
处理过程
验证
SQL 查询
所有这些都存储在 APEX 方案的内部表中。例如概念上的表：

APEX_APPLICATION_PAGES
APEX_APPLICATION_PAGE_ITEMS
APEX_APPLICATION_PAGE_REGIONS
APEX_APPLICATION_PAGE_PROC
你在 Page Designer 中看到的每个元素实际上都是元数据表中的一条记录。

在ORACLE 提供的虚拟机（Oracle AI database 26ai Free VirtualBox 设备）开发环境中记录的视图清单：

SELECT * FROM APEX_240200.APEX_APPLICATIONS
SELECT * FROM APEX_240200.APEX_APPLICATION_ALL_AUTH
SELECT * FROM APEX_240200.APEX_APPLICATION_AUTH
SELECT * FROM APEX_240200.APEX_APPLICATION_AUTHORIZATION
SELECT * FROM APEX_240200.APEX_APPLICATION_BC_ENTRIES
SELECT * FROM APEX_240200.APEX_APPLICATION_BREADCRUMBS
SELECT * FROM APEX_240200.APEX_APPLICATION_BUILD_OPTIONS
SELECT * FROM APEX_240200.APEX_APPLICATION_CACHING
SELECT * FROM APEX_240200.APEX_APPLICATION_COMPUTATIONS
SELECT * FROM APEX_240200.APEX_APPLICATION_GROUPS
SELECT * FROM APEX_240200.APEX_APPLICATION_ITEMS
SELECT * FROM APEX_240200.APEX_APPLICATION_LISTS
SELECT * FROM APEX_240200.APEX_APPLICATION_LIST_ENTRIES
SELECT * FROM APEX_240200.APEX_APPLICATION_LOCKED_PAGES
SELECT * FROM APEX_240200.APEX_APPLICATION_LOVS
SELECT * FROM APEX_240200.APEX_APPLICATION_LOV_COLS
SELECT * FROM APEX_240200.APEX_APPLICATION_LOV_ENTRIES
SELECT * FROM APEX_240200.APEX_APPLICATION_NAV_BAR
SELECT * FROM APEX_240200.APEX_APPLICATION_PAGES
SELECT * FROM APEX_240200.APEX_APPLICATION_PAGE_BRANCHES
SELECT * FROM APEX_240200.APEX_APPLICATION_PAGE_BUTTONS
SELECT * FROM APEX_240200.APEX_APPLICATION_PAGE_CHARTS
SELECT * FROM APEX_240200.APEX_APPLICATION_PAGE_CHART_A
SELECT * FROM APEX_240200.APEX_APPLICATION_PAGE_CHART_S
SELECT * FROM APEX_240200.APEX_APPLICATION_PAGE_COMP
SELECT * FROM APEX_240200.APEX_APPLICATION_PAGE_DA
SELECT * FROM APEX_240200.APEX_APPLICATION_PAGE_DA_ACTS
SELECT * FROM APEX_240200.APEX_APPLICATION_PAGE_DB_ITEMS
SELECT * FROM APEX_240200.APEX_APPLICATION_PAGE_GROUPS
SELECT * FROM APEX_240200.APEX_APPLICATION_PAGE_IR
SELECT * FROM APEX_240200.APEX_APPLICATION_PAGE_IR_CAT
SELECT * FROM APEX_240200.APEX_APPLICATION_PAGE_IR_CGRPS
SELECT * FROM APEX_240200.APEX_APPLICATION_PAGE_IR_COL
SELECT * FROM APEX_240200.APEX_APPLICATION_PAGE_IR_COMP
SELECT * FROM APEX_240200.APEX_APPLICATION_PAGE_IR_COND
SELECT * FROM APEX_240200.APEX_APPLICATION_PAGE_IR_GRPBY
SELECT * FROM APEX_240200.APEX_APPLICATION_PAGE_IR_PIVOT
SELECT * FROM APEX_240200.APEX_APPLICATION_PAGE_IR_PVAGG
SELECT * FROM APEX_240200.APEX_APPLICATION_PAGE_IR_PVSRT
SELECT * FROM APEX_240200.APEX_APPLICATION_PAGE_IR_RPT
SELECT * FROM APEX_240200.APEX_APPLICATION_PAGE_IR_SUB
SELECT * FROM APEX_240200.APEX_APPLICATION_PAGE_ITEMS
SELECT * FROM APEX_240200.APEX_APPLICATION_PAGE_MAP
SELECT * FROM APEX_240200.APEX_APPLICATION_PAGE_PROC
SELECT * FROM APEX_240200.APEX_APPLICATION_PAGE_REGIONS
SELECT * FROM APEX_240200.APEX_APPLICATION_PAGE_REG_COLS
SELECT * FROM APEX_240200.APEX_APPLICATION_PAGE_RPT
SELECT * FROM APEX_240200.APEX_APPLICATION_PAGE_RPT_COLS
SELECT * FROM APEX_240200.APEX_APPLICATION_PAGE_TREES
SELECT * FROM APEX_240200.APEX_APPLICATION_PAGE_VAL
SELECT * FROM APEX_240200.APEX_APPLICATION_PARENT_TABS
SELECT * FROM APEX_240200.APEX_APPLICATION_PROCESSES
SELECT * FROM APEX_240200.APEX_APPLICATION_RPT_LAYOUTS
SELECT * FROM APEX_240200.APEX_APPLICATION_RPT_QUERIES
SELECT * FROM APEX_240200.APEX_APPLICATION_SETTINGS
SELECT * FROM APEX_240200.APEX_APPLICATION_SHORTCUTS
SELECT * FROM APEX_240200.APEX_APPLICATION_STATIC_FILES
SELECT * FROM APEX_240200.APEX_APPLICATION_SUBSTITUTIONS
SELECT * FROM APEX_240200.APEX_APPLICATION_SUPP_OBJECTS
SELECT * FROM APEX_240200.APEX_APPLICATION_SUPP_OBJ_BOPT
SELECT * FROM APEX_240200.APEX_APPLICATION_SUPP_OBJ_CHCK
SELECT * FROM APEX_240200.APEX_APPLICATION_SUPP_OBJ_SCR
SELECT * FROM APEX_240200.APEX_APPLICATION_TABS
SELECT * FROM APEX_240200.APEX_APPLICATION_TEMPLATES
SELECT * FROM APEX_240200.APEX_APPLICATION_TEMP_BC
SELECT * FROM APEX_240200.APEX_APPLICATION_TEMP_BUTTON
SELECT * FROM APEX_240200.APEX_APPLICATION_TEMP_CALENDAR
SELECT * FROM APEX_240200.APEX_APPLICATION_TEMP_LABEL
SELECT * FROM APEX_240200.APEX_APPLICATION_TEMP_LIST
SELECT * FROM APEX_240200.APEX_APPLICATION_TEMP_PAGE
SELECT * FROM APEX_240200.APEX_APPLICATION_TEMP_POPUPLOV
SELECT * FROM APEX_240200.APEX_APPLICATION_TEMP_REGION
SELECT * FROM APEX_240200.APEX_APPLICATION_TEMP_REPORT
SELECT * FROM APEX_240200.APEX_APPLICATION_THEMES
SELECT * FROM APEX_240200.APEX_APPLICATION_THEME_FILES
SELECT * FROM APEX_240200.APEX_APPLICATION_THEME_STYLES
SELECT * FROM APEX_240200.APEX_APPLICATION_TRANSLATIONS
SELECT * FROM APEX_240200.APEX_APPLICATION_TRANS_DYNAMIC
SELECT * FROM APEX_240200.APEX_APPLICATION_TRANS_MAP
SELECT * FROM APEX_240200.APEX_APPLICATION_TRANS_REPOS
SELECT * FROM APEX_240200.APEX_APPLICATION_TREES
SELECT * FROM APEX_240200.APEX_APPLICATION_WEB_SERVICES