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…
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…
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…