Give the sequence of execution of the various report triggers?

Give the sequence of execution of the various report triggers?
by

1 Answer

Answer :

Before form , After form , Before report, Between page, After report.
by

Related questions

Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?

Description : Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?

Last Answer : a. ON-INSERT b. POST-INSERT c. PRE-INSERT

What are the types of triggers and how the sequence of firing in text item

Description : What are the types of triggers and how the sequence of firing in text item

Last Answer : Triggers can be classified as Key Triggers, Mouse Triggers ,Navigational Triggers. Key Triggers :: Key Triggers are fired as a result of Key action.e.g :: Key-next-field, Key-up,Key-Down Mouse Triggers :: Mouse ... :: a) pre - text b) when new item c) key-next d) when validate e) post text

At what point of report execution is the before Report trigger fired?

Description : At what point of report execution is the before Report trigger fired?

Last Answer : After the query is executed but before the report is executed and the records are displayed.

Is the After report trigger fired if the report execution fails?

Description : Is the After report trigger fired if the report execution fails?

Last Answer : Yes.

How can you execute the user defined triggers in forms 3.0 ?

Description : How can you execute the user defined triggers in forms 3.0 ?

Last Answer : Execute Trigger (trigger-name)

What are Database Triggers and Stored Procedures

Description : What are Database Triggers and Stored Procedures

Last Answer : Database Triggers :: Database Triggers are Procedures that are automatically executed as a result of insert in, update to, or delete from table. Database triggers have the values old and new to ... procedures is that many users can use the same procedure in compiled and ready to use format.

Difference between database triggers and form triggers?

Description : Difference between database triggers and form triggers?

Last Answer : Data base trigger(DBT) fires when a DML operation is performed on a data base table. Form trigger(FT) Fires when user presses a key or navigates between fields on the screen -Can be row ... other database triggers to fire.Can cause other database triggers to fire, but not other form triggers.

How many types of database triggers can be specified on a table ? What are they ?

Description : How many types of database triggers can be specified on a table ? What are they ?

Last Answer : Insert Update Delete Before Row o.k. o.k. o.k. After Row o.k. o.k. o.k. Before Statement o.k. o.k. o.k. After Statement o.k. o.k. o.k. If FOR EACH ROW clause is ... for each Row affected by the statement. If WHEN clause is specified, the trigger fires according to the returned Boolean value.

What are the triggers associated with a check box?

Description : What are the triggers associated with a check box?

Last Answer : Only When-checkbox-activated Trigger associated with a Check box.

What triggers are associated with the radio group?

Description : What triggers are associated with the radio group?

Last Answer : Only when-radio-changed trigger associated with radio group Visual Attributes.

What are the triggers associated with the image item?

Description : What are the triggers associated with the image item?

Last Answer : When-Image-activated(Fires when the operator double clicks on an image Items) When-image-pressed(fires when the operator selects or deselects the image item)

List the windows event triggers available in Forms 4.0?

Description : List the windows event triggers available in Forms 4.0?

Last Answer : When-window-activated, when-window-closed, when-window-deactivated, when-window-resized

What are the types of TRIGGERS ?

Description : What are the types of TRIGGERS ?

Last Answer : 1. Navigational Triggers. 2. Transaction Triggers.

What are the different types of key triggers ?

Description : What are the different types of key triggers ?

Last Answer : Function Key Key-function Key-others Key-startup

State the order in which these triggers are executed ?

Description : State the order in which these triggers are executed ?

Last Answer : POST-FIELD,ON-VALIDATE-FIELD,POST-CHANGE and KEY-NEXTFLD. KEY-NEXTFLD,POST-CHANGE, ON-VALIDATE-FIELD, POST-FIELD. g.

What is the usage of an ON-INSERT,ON-DELETE and ON- UPDATE TRIGGERS ? These triggers are execu

Description : What is the usage of an ON-INSERT,ON-DELETE and ON-UPDATE TRIGGERS ? These triggers are execu

Last Answer : These triggers are executes when inserting, deleting and updating operations are performed and can be used to change the default function of insert, delete or update respectively. For Eg, instead of inserting a row in a table an existing row can be updated in the same table.

What are the different default triggers created when Master Deletes Property is set to Cascade?

Description : What are the different default triggers created when Master Deletes Property is set to Cascade?

Last Answer : Master Deletes Property Resulting Triggers --------------------------------------------------- Cascading On-Clear-Details On-Populate-Details Pre-delete

What are the different default triggers created when Master Deletes Property is set to isolated?

Description : What are the different default triggers created when Master Deletes Property is set to isolated?

Last Answer : Master Deletes Property Resulting Triggers --------------------------------------------------- Isolated On-Clear-Details On-Populate-Details

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

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

Last Answer : Master Deletes Property Resulting Triggers ---------------------------------------------------- Non-Isolated(the default) On-Check-Delete-Master On-Clear-Details On-Populate-Details

What are the master-detail triggers?\

Description : What are the master-detail triggers?\

Last Answer : On Check_delete_masterOn_clear_detailsOn_populate_details

What is the use of transactional triggers?

Description : What is the use of transactional triggers?

Last Answer : Using transactional triggers we can control or modify the default functionality of the oracle forms.

What are the various methods of performing a calculation in a report ?

Description : What are the various methods of performing a calculation in a report ?

Last Answer : 1. Perform the calculation in the SQL statements itself. 2. Use a calculated / summary column in the data model.

Which of the following is correct? a) Module A uses Module B if a correct version of B must be present for A to execute correctly b) Module A calls (or invokes ) module B if B triggers execution of A c) All of the mentioned d) None of the mentioned

Description : Which of the following is correct? a) Module A uses Module B if a correct version of B must be present for A to execute correctly b) Module A calls (or invokes ) module B if B triggers execution of A c) All of the mentioned d) None of the mentioned

Last Answer : Module A uses Module B if a correct version of B must be present for A to execute correctly

What is Execution Plan ?

Description : What is Execution Plan ?

Last Answer : The combinations of the steps the optimizer chooses to execute a statement is called an execution plan.

What are two virtual tables available during database trigger execution ?

Description : What are two virtual tables available during database trigger execution ?

Last Answer : The table columns are referred as OLD.column_name and NEW.column_name. For triggers related to INSERT only NEW.column_name values only available. For triggers related to UPDATE only OLD. ... values only available. For triggers related to DELETE only OLD.column_name values only available.

What are the different approaches used by Optimizer in choosing an execution plan ?

Description : What are the different approaches used by Optimizer in choosing an execution plan ?

Last Answer : Rule-based and Cost-based.

Can you see Execution Plan of a statement?

Description : Can you see Execution Plan of a statement?

Last Answer : YES. In many ways, for example from GUI based tools like TOAD, Oracle SQL Developer. Configuring AUTOTRACE, a SQL*Plus facility AUTOTRACE is a facility within SQL*Plus to show us the explain plan of the ... - Like SET AUTOTRACE ON, but suppresses the printing of the user's query output, if any.

How many different triggers are available in Report?

Description : How many different triggers are available in Report?

Last Answer : There are five types of triggers in report 6i 1) Before report trigger 2) After report trigger 3) Before Parameter trigger 4) After parameter trigger 5) Between pages trigger

How can a button be used in a report to give a drill down facility?

Description : How can a button be used in a report to give a drill down facility?

Last Answer : By setting the action associated with button to Execute pl/sql option and using the SRW.Run_report function.

With respect to factors that affect reorganization, when a single change triggers off a sequence of related changes, it is called the (a) Halo effect ; (b) Hawthorne effect ; (c) Domino effect ; (d) Sensitivity effect

Description : With respect to factors that affect reorganization, when a single change triggers off a sequence of related changes, it is called the (a) Halo effect ; (b) Hawthorne effect ; (c) Domino effect ; (d) Sensitivity effect

Last Answer :  (c) Domino effect ;

What are the various types of database triggers ?

Description : What are the various types of database triggers ?

Last Answer : There are 12 types of triggers, they are combination of : Insert, Delete and Update Triggers. Before and After Triggers. Row and Statement Triggers. (3*2*2=12)

How many minimum groups are required for a matrix report

Description : How many minimum groups are required for a matrix report

Last Answer : The minimum number of groups in matrix report are 4

s it possible to disable the parameter from while running the report?

Description : s it possible to disable the parameter from while running the report?

Last Answer : Yes

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

Description : Can a field be used in a report without it appearing in any data group?

Last Answer : Yes

What are the minimum number of groups required for a matrix report

Description : What are the minimum number of groups required for a matrix report

Last Answer : The minimum of groups required for a matrix report are 4 e

Can u run the report with out a parameter form

Description : Can u run the report with out a parameter form

Last Answer : Yes it is possible to run the report without parameter form by setting the PARAM value to Null

Can u have more than one layout in report

Description : Can u have more than one layout in report

Last Answer : It is possible to have more than one layout in a report by using the additional layout option in the layout editor.

To display the page no. for each page on a report what would be the source & logical page no. or & of physical page no.?

Description : To display the page no. for each page on a report what would be the source & logical page no. or & of physical page no.?

Last Answer : & physical page no.

How can a text file be attached to a report while creating in the report writer?

Description : How can a text file be attached to a report while creating in the report writer?

Last Answer : By using the link file property in the layout boiler plate property sheet.

How can a square be drawn in the layout editor of the report writer?

Description : How can a square be drawn in the layout editor of the Report writer?

Last Answer : By using the rectangle tool while pressing the (Constraint) key.

Is it possible to modify an external query in a report which contains it?

Description : Is it possible to modify an external query in a report which contains it?

Last Answer : No.

What are the ways to monitor the performance of the report?

Description : What are the ways to monitor the performance of the report?

Last Answer : Use reports profile executable statement. Use SQL trace facility.

What are the two types of views available in the object navigator(specific to report 2.5)?

Description : What are the two types of views available in the object navigator(specific to report 2.5)?

Last Answer : View by structure and view by type .

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied?

Description : If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied?

Last Answer : While both reports 2.0 and 2.5 create the parameter, report 2.5 gives a message that a bind parameter has been created.

What is a Sequence ?

Description : What is a Sequence ?

Last Answer : A sequence generates a serial list of unique numbers for numerical columns of a database's tables.

What is CYCLE/NO CYCLE in a Sequence ?

Description : What is CYCLE/NO CYCLE in a Sequence ?

Last Answer : CYCLE specifies that the sequence continues to generate values after reaching either maximum or minimum value. After pan ascending sequence reaches its maximum value, it generates its minimum value. ... that the sequence cannot generate more values after reaching its maximum or minimum value.

How to access the current value and next value from a sequence ? Is it possible to access the current value in a session before accessing next value ?

Description : How to access the current value and next value from a sequence ? Is it possible to access the current value in a session before accessing next value ?

Last Answer : Sequence name CURRVAL, Sequence name NEXTVAL.It is not possible. Only if you access next value in the session, current value can be accessed.

What is an Oracle sequence?

Description : What is an Oracle sequence?

Last Answer : A sequence generates a serial list of unique numbers for numerical columns of a database's tables.

What is the use of break group? What are the various sub events a mouse double click event involves?

Description : What is the use of break group? What are the various sub events a mouse double click event involves?

Last Answer : A break group is used to display one record for one group ones. While multiple related records in other group can be displayed.

What are the various sub events a mouse double click event involves? What are the various sub events a mouse double click event involves?

Description : What are the various sub events a mouse double click event involves? What are the various sub events a mouse double click event involves?

Last Answer : Double clicking the mouse consists of the mouse down, mouse up, mouse click, mouse down & mouse up events.