Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


What are the type of triggers available in Oracle Reports ?

Answers were Sorted based on User's Feedback



What are the type of triggers available in Oracle Reports ?..

Answer / satbir

There are five types of trigger in Oracle Reports

Before Parameter Form
Fires before the Runtime Parameter Form are displayed. Can
access the PL/SQL global variables, report level columns
and manipulate accordingly.

After Parameter Form
Fires after the Runtime Parameter form are displayed. Used
to validate the parameter values.

Before Report
Fires before the report is executed but after the queries
is parsed and date is fetched.

Between Pages
Fires before each page of the report are formatted, except
the very first page. This page is used to customize page
formatting.

After Report
Fires after the report previewer are exited, or after
report output is sent to a specified destination.

Is This Answer Correct ?    113 Yes 16 No

What are the type of triggers available in Oracle Reports ?..

Answer / anuragrajverma

There are eight report triggers.
Global triggers called the Report Triggers :
(1) Before Parameter Form
(2) After Parameter Form
(3) Before Report
(4) After Report
(5) Between Pages
Other Triggers :
(1) Validation Triggers
(2) Format Triggers
(3) Action Triggers
/*******************************/
(1) Before Parameter Form
Fires before the Runtime Parameter Form is displayed. From
this trigger, you can access and
change the values of parameters, PL/SQL global variables,
and report-level columns. (Note : If the
Runtime Parameter Form is suppressed, this trigger still
fires. Consequently, you can use this trigger
for validation of command line parameters).
(2) After Parameter Form
Fires after the Runtime Parameter Form is displayed.
Fromfires. Consequently, you can use this trigger for
validation of command line parameters or other data).
(3) Before Report
Fires before the report is executed but after queries are
parsed and data is fetched.
(4) Between Pages
Fires before each page of the report is formatted, except
the very first page. This trigger can be
used for customized page formatting. (Note : In the
Previewer, this trigger only fires the first time that
you go to a page. If you subsequently return to the page,
the trigger does not fire again.)
(5) After Report
Fires after you exit the Previewer, or after report output
is sent to a specified destination, such
as a file, a printer, or an Oracle*Mail userid. This
trigger can be used to clean up any initial processing
that was done, such as deleting tables. Note, however, that
this trigger always fires, whether or not
your report completed successfully.
(6) Validation Triggers
Validation Triggers are PL/SQL functions that are executed
when parameter values are
specified on the command line and when you accept the
Runtime Parameter Form. (Notice that this
means each Validation Trigger may fire twice when you
execute the report). Validation Triggers are
also used to validate the Initial Value of the parameter in
the Parameter property sheet.
(7) Format Triggers
Format Triggers are PL/SQL functions executed before the
object is formatted. The trigger can
be used to dynamically change the formatting attributes of
the object.
(8) Action Triggers
Action Triggers are PL/SQL procedures executed when a
button is selected in the Previewer.
The trigger can be used to dynamically call another report
(drill down) or execute any other PL/SQL.

Is This Answer Correct ?    90 Yes 7 No

What are the type of triggers available in Oracle Reports ?..

Answer / dinesh mohan upadhyay

trere are five types report trigger
1 before parameter form
2 after parameter form
3 before report
4 between pages
5 after report

Is This Answer Correct ?    83 Yes 8 No

Post New Answer



More Oracle Forms Reports Interview Questions

where do u put the report file

0 Answers  


what are bind variables?

0 Answers  


How many maximum number of radio buttons can you assign to a radio group?

1 Answers  


What is a matrix report and how many minimum groups are required to prepare the same?

0 Answers  


What are the different defaust triggers created when Master Deletes Property is set to Non-isolated?

1 Answers  






Can you change the color of the push button in design time?

2 Answers  


Can a field be used in a report wihtout it appearing in any data group?

1 Answers  


How does the command POST differs from COMMIT ?

2 Answers  


From which designation is it preferred to send the output to the printed?

1 Answers  


how do u place it in required folder

0 Answers  


what is a package n what r the packages availbla in report

0 Answers   Convergys,


What is an implicit anchor and how is it a different form explicit anchor in a report builder?

0 Answers  






Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (509)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)