Oracle

May13

Oracle Application Express Listener 2.0.x configuration

Installing Oracle Application Express is Windows Machine has never been so easy for me. This is the 6th time I have installed Oracle Application Express (APEX) version 4.2.5.x in Windows 7 Pro 64 bit machine. I have used GlassFishâ„¢ server in my all...
Read More
Jun14

Get item session value in APEX using jQuery

You can access the session value of any page item in APEX quite easily using jQuery. Session value can be retrieved using &PX_ITEM_NAME. tag even in html code. APEX replace this tag with the item session value. Cool yeah. Recently I have used this...
Read More
Mar25

Create dynamic URL in Oracle SQL

Creating a dynamic field or formatting any column is quite easy using case statement in SQL query. In the recent forum post in Oracle Apex forum I have provided an example how to create dynamic URL based on the value of another field. In this example...
Read More
Jan08

Clear session state in Oracle APEX after an AJAX action

How to clear the session state in Oracle Application Express? Well it is quite easy to do with PL/SQL however tricky to do with javascript or jQuery. Basically I have implemented an AJAX request based on couple of page items but I want clear the session...
Read More
Nov29

Redirect to another page based on select list value in APEX

Redirect user to different page in APEX is tricky some times. I have tried to use button and branch to page but did not have good luck in one of my application. It works in one case but does not work in another. I had mess around with the branch at different...
Read More