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…
Add additional content or append content in jQuery accordion
Recently I have replied to an forum inquiry in Oracle APEX forum about appending accordion content from html region. Here is the original blog post – https://forums.oracle.com/forums/thread.jspa?messageID=10926257#10926257 You can append…
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…