Oracle Application Express / Oracle APEX - web 應用程式快速開發平台

Oracle APEX 一種使用http browser 直接在server開發的平台 link us link cn

---

Free Oracle-APEX hosting
* http://www.maxapex.com/

---

ORACLE 10G express edition / Oracle 10G XE 內建 APEX 2.1

---

ORACLE 11G 起搭配 APEX 3.1.2 > 3.2
Try it link

---

APEX 4
APEX Oracle Application Express 4.0 Early Adopter Phase III (EA3) is now available.link
Try it link

* APEX 4.0有 bug  , 對我重要的是 dblink bug 無法透過 APEX 使用 dblink
* APEX 4.0.1 集合多個 patches 發佈新版 2010/08/18

---

APEX 4.0.1
* APEX 4.0 upgrade to 4.0.1 不成功, 網路上建議 Remove APEX , 重新安裝 4.0.1
* APEX 4.0.1 直接安裝

Remove APEX

* SQL> drop user FLOWS_030000 cascade; <= when original APEX 3.x
* SQL> drop user FLOWS_020100 cascade; <= when original APEX 2.x
* SQL> drop user FLOWS_FILES cascade;
* SQL> !pwd <=確認目錄 , 必須在 unzip 目錄 apex 中
* SQL> @apxremov.sql

Install new APEX 4.0.1

* SQL> @apexins.sql SYSAUX SYSAUX TEMP /i/ <= run update sql
* SQL> @apxldimg.sql C:temposoftapex <=run sql for images
* SQL> @apxchpwd.sql <= run sql for initial ADMIN password

---

Oracle - Technology & Gossip tw link
APEX Web Services Integration (Goofgle mpas API) link
----
Easy Apex link
Upgrading Oracle Apex to Version 4.0 on Oracle 10g/XE Database link