1. APEX 通过PL/SQL动态展示区域中动态内容
Create Dynamic Content Region in Oracle APEX (PL/SQL Dynamic Content)
参考：https://o7planning.org/en/10447/create-dynamic-content-region-in-oracle-apex
1.1. Introduction
This document is based on:
· Oracle APEX 5.0
Use 'PL/SQL Dynamic Content' you can create any HTML content within a region.
1.2. Creating dynamic HTML content region
1) 创建空白页
页码：200
名称：Dynamic HTML Example 1
导航：创建新导航栏，名称同页码；
2) 创建新区域
标识》标题：Dept-Emp Tree
标识》类型：PL/SQL 动态内容
源》PLSQL代码：
|
Declare Cursor c_Dept Is Select Deptno ,Dname ,Loc From Dept; -- Cursor c_Emp(p_Deptno Number) Is Select Empno ,Ename ,Job From Emp Where Emp.Deptno = p_Deptno; Begin Htp.p('
');
-- For Rec_d In c_Dept Loop Htp.p(' ');
Htp.p(' ' || Rec_d.Dname || '');
-- For Rec_e In c_Emp(Rec_d.Deptno) Loop Htp.p(' ' || Rec_e.Ename || ' ');
End Loop; -- Htp.p(' ');
End Loop; -- Htp.p(' ');
End; |
3) 保存执行
