If you want to update all IR with a single code, mb you should try with declaring a cursor, smth like this:
DECLARE SqlQuery VARCHAR2 (2000 CHAR); BEGIN -- You select sql query of IR from your admin application ! SELECT sql_query INTO SqlQuery FROM apex_application_page_ir WHERE page_id = 10 and application_id = 100; -- For example IR in your admin application (page - 10, application 100) ! -- dbms_output.put_line(SqlQuery); -- Check if everything is ok inside Apex sql workshop ! -- Now you update sql query of IR in your client application ! UPDATE apex_application_page_ir SET sql_query = SqlQuery WHERE page_id = 15 and application_id = 105; -- For example IR in your client application (page - 15, application 105) END;
then loop through it and update client application.
DECLARE CURSOR MY_IRS IS (SELECT * FROM apex_application_page_ir where application_id = 100);
Andre wrote:No, that's not correct. I have for example the following tables:
So are you saying that the end users have tha ability to change the underlying database schema through the admin application by adding and dropping columns from tables?