Oracle ERP APEX开发指南
Author: Creation Date: Last Updated: Document Ref: Version:
Approvals:
刘俊杰 April 10, 2014 July 14, 2019
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之系统探究 ...................................................................................................... 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服务器。
