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('

' || 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) 保存执行