What are dynamic reports? How will you create them

Questions by rafioracledeveloper

Showing Answers 1 - 3 of 3 Answers

asifinet

  • Feb 15th, 2013
 

Dynamic Reports are the Reports which is based on the GLOBAL_TEMPORARY TABLE. can be used in BEFORE RUN REPORT Trigger to populate the Data into that table by calling function/procedure. After report is generated you can use commit; statment in the AFTER RUN REPORT Trigger to clear off the Table release the Storage from the Temporary Table. Please check the Command how to create the Global Temporary Table below.

CREATE GLOBAL TEMPORARY TABLE admin_work_area
(startdate DATE,
enddate DATE,
class CHAR(20))
ON COMMIT DELETE ROWS;

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions