Oracle - APEX开发指南

Oracle ERP APEX开发指南

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

Approvals:

错误！未指定书签。4 August 24, 2015

1.0

Oralce之APEX开发指南

Document Control

Change Record

Reviewers

Distribution

3

Date Author Version Change Reference 错误！未指 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之系统探究 ...................................................................................................... 2 APEX简介 ............................................................................................................... 2 环境搭建 .................................................................................................................. 3 APEX账户管理 ....................................................................................................... 6 待定 .......................................................................................................................... 8 APEX –开发 ............................................................................................................... 9 开发概要 .................................................................................................................. 9 页面布局、美化 .................................................................................................... 10 APEX控件 ............................................................................................................. 13 Report常用增删改 ................................................................................................ 16 文件上传下载 ........................................................................................................ 19 使用CSS与JS .......................................................................................................... 25 图表、报表 ............................................................................................................ 28 Application Express Free Plugins ..................................................................... 35 APEX部署 ............................................................................................................. 37 APEX之调试、常用技巧、API ............................................................................. 39 APEX–EBS集成 ....................................................................................................... 40 4.1. EBS中配置APEX页面调用 ................................................................................... 40

Reference ................................................................................................................. 43 Open and Closed Issues for this Deliverable...................................................... 44 Open Issues ..................................................................................................................... 44 Closed Issues .................................................................................................................. 44

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服务器。