Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What are different report triggers and what is their firing sequence?

April 26, 2017different firing report sequence triggers

0

Posted

What are different report triggers and what is their firing sequence?

1 Answer

0

Posted

• Before Report • After Report • Before Parameter Form • After Parameter Form • Between Pages The Firing sequence for report triggers is Before Parameter Form – After Parameter Form – Before Report – Between Pages – After Report. 3. What is the use of cursors in PL/SQL? What is REF Cursor? The cursor is used to handle multiple row query in PL/SQL. Oracle uses implicit cursors to handle all its queries. Oracle uses unnamed memory spaces to store data used in implicit cursors, with REF cursors you can define a cursor variable which will point to that memory space and can be used like pointers in our 3GLs. 4. What is record group? Record group are used with LOVs to hold sql query for your list of values. The record group can contain static data as well it can access data from database tables thru sql queries. 5. What is a FlexField? What are Descriptive and Key Flexfields? An Oracle Applications field made up of segments. Each segment has an assigned name and a set of valid values. Oracle