Fancybox in APEX dynamic report
Using fancybox in Oracle Application Express (APEX) can increase the page load performance specially when You have lot of items in one page and user needs to scroll down to…
Counting record and sorting with fiscal month in APEX chart
Recently in one of my project that built in Oracle APEX. This is basically a Change Request System (CRS) built in APEX to submit or log any change request by…
Formatting report column in currency in Oracle
Here is the little script to convert number to char and trailing with $ symbol. select new_cost, to_char( old_cost,'$999,99,999') as original_cost from cpt_products; It displays result like – 12227 $6,000…
Insert multiple records into a table from a TextBox
Sometimes you may require to insert multiple records from one text field (textarea). This can be done for multiple user choices or voting controls etc. In this example I will…