How To Change Dynamically Reported SQL Queries In Oracle Apex?
How To Change Dynamically Reported SQL Queries In Oracle Apex? How To Change Dynamically Reported SQL Queries In Oracle Apex? You Can Use Pl / SQL Function Returning SQL Query To Dynamically Modify The SQL Query In Oracle Apex Application Reports. Follow These Steps To Change Dynamically Reported SQL Queries: 1. Create A New Item First. Name= P85_TABLE_NAME
Type= Select List
List of Values
Type = SQL Query Get list of all tables in Oracle Database Get list of all tables in Oracle Database
SQL Query = SELECT TABLE_NAME D, TABLE_NAME R FROM USER_TABLES; 2. Create A New Classic Report. Name = Classic Report. Source- Location = Local Database Type = Function Body returning SQL Query Language = PL/SQL PL/SQL Function Body returning SQL Query = DECLARE
l_str VARCHAR2 (4000);
BEGIN
l_str :=
CASE
WHEN :P85_TABLE_NAME IS NULL THEN 'select * from part_7'
ELSE 'select * from ' || :P85_TABLE_N…
