Oracle之APEX深入开发指南要点

Oracle ERP APEX开发指南

Author: Creation Date: Last Updated: Document Ref: Version:

Approvals:

刘俊杰 April 10, 2014 January 8, 2020

1.0

Oralce之APEX开发指南

Document Control

Change Record

Reviewers

Distribution

3

Date Author Version Change Reference 10-Apr-13 Junjie.liu 1.0 No Previous Document

Name Position

Copy No. Name Location 1 2 3 4

Note To Holders:

If you receive an electronic copy of this document and print it out, please write your name on the equivalent of the cover page, for document control purposes. If you receive a hard copy of this document, please write your name on the front cover, for document control purposes.

Oralce之APEX开发指南

Contents

Document Control .................................................................................................................. ii 1.

1.1.

1.2. 1.3. 1.4. 2.

2.1. 2.2. 2.3. 2.4. 2.5. 2.6. 2.7. 2.8. 2.9. 3. 4. 5. 6.

APEX之系统探究 ...................................................................................................... 4 APEX简介 ............................................................................................................... 4 环境搭建 .................................................................................................................. 5 APEX账户管理 ....................................................................................................... 8 待定 ........................................................................................................................ 10 APEX –开发 ............................................................................................................. 11 开发概要 ................................................................................................................ 11 页面布局、美化 .................................................................................................... 12 APEX控件 ............................................................................................................. 15 Report常用增删改 ................................................................................................ 18 文件上传下载 ........................................................................................................ 21 使用CSS与JS .......................................................................................................... 27 图表、报表 ............................................................................................................ 30 Application Express Free Plugins ..................................................................... 37 APEX部署 ............................................................................................................. 39 APEX之调试、常用技巧、API ............................................................................. 41 APEX–EBS集成 ....................................................................................................... 42 4.1. EBS中配置APEX页面调用 ................................................................................... 42

Reference ................................................................................................................. 45 Open and Closed Issues for this Deliverable...................................................... 46 Open Issues ..................................................................................................................... 46 Closed Issues .................................................................................................................. 46

Oralce之APEX开发指南

1. APEX之系统探究

1.1. APEX简介

1.1.1.

概述

1) Oracle Application Express是基于Web浏览器的网络即时开发、部署、运行。 2) Oracle Application Express所有页面都是存储于数据库，类似于EBS的Form个性

化。 3) Oracle ApplicationExpress具有易用性、灵活性及Web的安全性、集成性、可伸缩。 1.1.2.

体系结构

Application Express使用用户计算机上的Web浏览器通过Web监听程序与Oracle

数据库通信。开发，部署或运行时不需要浏览器之外的任何其他客户机软件。 Application Express页使用浏览器中的HTML来呈现。页请求和提交发送到Oracle数据库中的Application Express引擎。 1.1.3.

运行环境

1) 浏览器要求

Web浏览器必须支持Java脚本和HTML4.0和CSS1.0标准。Oracle Application Express建议使用以下浏览器进行开发或查看应用程序：

? ? ? ?

微软Internet Explorer7.0或更高版本 Mozilla Firefox 3.6或更高版本 谷歌Chrome4.0或更高版本 苹果Safari4.0或更高版本

2) 数据库及HTTP服务器要求

1) 2)

Oracle Database 11g release 1or 2,自带pl/sql网关配置比较简单，能够直接提供HTTP服务器的功能。

Oracle Database 10g,必须使用mod_plsql插件或是Oracle Application Express监听器来连接专业的HTTP服务器。