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
Mar26

Create trigger to set column value depending on another table column value in Oracle database

You can create a trigger in Oracle database to set column value dynamically depending on another table column value. Recently some asked this question in Oracle Apex Forum and here was my suggestion for creating trigger to check if the new value exists...
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
Mar18

Calculate BCI/CPI using PL/SQL and Oracle table

Recently I was working in a project to calculate BCI (Building Cost Index) for the assets in the asset management system. After messing around with different systems and methodology I have come across a simple solution that calculate the CPI (Consumer...
Read More