Posts by Venkatesh Balasubramanian

How to query BI bursting

Description:   One of the very good features of Oracle BI Publisher is its ability to burst and send the reports to multiple users simultaneously. Using BI Publisher’s bursting feature, we can split a single batch report into individual reports to be delivered to multiple destinations. We can apply a different template,…

Read More

Get Filtered Columns and Values in APEX Interactive Report

Description: In order to get the filtered columns and their corresponding values in APEX Interactive Report, we can use this code. So if the user selects multiple filters in IR…

Read More

Full View or Normal View of Tabular Form Columns in APEX

Description:A tabular form enables users to update multiple rows in a table at once from a single page. You can use the Tabular Form Wizard to create a tabular form…

Read More

Excel Merge and Download using Custom Template in APEX

Description: For Merging cells in Excel and for other CSS in download property, i.e., to create downloadable XLS formatted sheets from any version of APEX use the following steps: Create…

Read More

Report Builder Components

 Description: Report Builder is a report creation tool which allows users to create, manage, and publish reports to SQL Server Reporting Services. We can also create shared datasets with the…

Read More

Conditional Link in APEX Tabular Form

Description: Conditional link is the common requirement all over application development. As a requirement goes with Users and Roles, Conditionally, we may have to hide/disable links for different users and…

Read More

Conditional Alert or Comments on Hover

Description: Conditional Alert / Comments on Hover is a common requirement, In Old days, it is common to use a drill-down pop-up user has to click and view comments, and…

Read More

Region Interface – Shipping

Description: The post and steps describe the process of Region Interface – Shipping to create the country, state, city, and area Pincode with the help of interface and base tables.…

Read More

Parsing Comma Separated string in WHERE Clause of SQL Statement in Oracle Forms

Description: In some cases, we get a comma-separated string as output (say from another select statement or block) that we would need to pass to the IN clause of a…

Read More

Oracle Multitenant in Database 12c Enterprise Edition

Description: Oracle Multitenant – an Oracle Database 12c Enterprise Edition option – introduces a new architecture that enables customers to easily consolidate multiple databases into a standardized database version that…

Read More