Install and Configure Oracle Application Express Apex 5.0, 4.2.6, 4.2.x with Embedded PL/SQL Gateway

1. Download Software as Zip file from OTN http://www.oracle.com/technetwork/developer- tools/apex/downloads/index.html 2.Unzip apex_5.0_en.zip Software to ORACLE_HOME directory, it will create a directory called Apex 3. Login to SQLPLUS as SYSDBA in database where you will create the Apex instance. Create a tablespace called "apex" for the Apex 5 installation $ cd $ORACLE_HOME/apex SELECT dbms_xdb.gethttpport FROM dual; …

Rapid Web Deployment Tool

I normally post to this blog things relevant to Databases in general and Oracle in particular but once in a while it is good to go a little off topic. In addition to Oracle Apex, which most of Oracle DBA's have some sort of an idea about. There is a tool (or rather framework) which …

Install Oracle Apex in 11gR2

Source -->  http://oraexplorer.com/2007/11/oracle-apex-in-11g-installation/ Today I installed Oracle 11g (11.1.0.6) on my machine. I did not realize that Oracle APEX is a part of the standard database components. So after the 11g installation, I just follow simple steps (shown later below) for the post-installation. In order to access the APEX application, either the embedded PL/SQL gateway …

Oracle APEX : Source tables for forms and tabular forms must have a primary key.

While creating a' Report and Form' Application in Oracle APEX if your using a table which has no primary key then you might get an error.  I would not recommend to do the below procedure in a production environment. It is better to create a new table with a primary key column  and copy the …