State the order in which these triggers are executed ?

1 Answer

Answer :

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

Related questions

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

Last Answer : Execute Trigger (trigger-name)

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

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.

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.

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.

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

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

Description : What triggers are associated with the radio group?

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

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)

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

Description : What are the types of TRIGGERS ?

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

Description : What are the different types of key triggers ?

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

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

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.

Description : Give the sequence of execution of the various report triggers?

Last Answer : Before form , After form , Before report, Between page, After report.

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

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

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

Description : What are the master-detail triggers?\

Last Answer : On Check_delete_masterOn_clear_detailsOn_populate_details

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.

Description : A query fetched 10 records How many times does a PRE-QUERY Trigger and POST-QUERY Trigger will get executed ?

Last Answer : PRE-QUERY fires once. POST-QUERY fires 10 times.

Description : When is PRE-QUERY trigger executed ?

Last Answer : When Execute-query or count-query Package procedures are invoked.

Description : Where is a procedure return in an external pl/sql library executed at the client or at the server?

Last Answer : At the client.

Description : Where is the external query executed at the client or the server?

Last Answer : At the server.

Description : How many LONG columns are allowed in a table ? Is it possible to use LONG columns in WHERE clause or ORDER BY ?

Last Answer : Only one LONG columns is allowed. It is not possible to use LONG column in WHERE or ORDER BY clause.

Description : Write the order of precedence for validation of a column in a table ?

Last Answer : I. done using Database triggers. ii. done using Integarity Constraints.?

Description : How can a break order be created on a column in an existing group? What are the various sub events a mouse double click event involves?

Last Answer : By dragging the column outside the group.

Description : If a break order is set on a column would it affect columns which are under the column?

Last Answer : No

Description : What is the purpose of the product order option in the column property sheet?

Last Answer : To specify the order of individual group evaluation in a cross products.

Description : Select NORTH', CUSTOMER From CUST_DTLS Where REGION = N' Order By CUSTOMER Union Select EAST', CUSTOMER From CUST_DTLS Where REGION = E' Order By CUSTOMER The above is a) Not an error b) Error - ... ' and SOUTH' c) Error - the string should be in double quotes d) Error - ORDER BY clause

Last Answer : d) Error - ORDER BY clause

Description : What is the minimum number of instances you need to have in order to create a RAC?

Last Answer : 1. You can create a RAC with just one server.

Description : What is the most important requirement in order to use RMAN to make consistent hot backups

Last Answer : Your database has to be in ARCHIVELOG mode.

Description : How the effectiveness of the alpha-beta pruning gets increased? a) Depends on the nodes b) Depends on the order in which they are executed c) All of the mentioned d) None of the mentioned

Last Answer : a) Depends on the nodes

Description : 90. When a telephone order is made, it should be documented by the nurse who is receiving the order. The following should be included in the order to be executed except

Last Answer : A. Time the call was made and its duration

Description : Redditors, what is the thing that triggers you the most?

Last Answer : People that get triggered.

Description : Is this taking "triggers" a bit too far?

Last Answer : Can you give me a source of this, like the original episode where his line came from? I don’t think I can properly judge this without a proper context.

Description : What thoughts are guaranteed triggers of joyful feelings for you?

Last Answer : Oddly enough, I can thank Loli for this. Guardians Of The Galaxy, one and two. I like to collect these and line em up on my console. Baby Groot Drax's laugh. You made me kick grass! ... tough time finding cheerful moments these days, but those two movies are my reliable go to. Thanks, loli. :-)

Description : Why are so few women found behind the triggers in America’s mass shooting sprees?

Last Answer : Are men just wired for random killing No. Well, some of them are somewhat set up for it, due to our dysfunctional culture which has men shut down their compassionate/emotional aspects, swallow shame and ... 't train them to relate to violence in the same ways it trains men to relate to violence.

Description : Do you have any emotional triggers that you know of?

Last Answer : Yeah, you know, patriarchy and sexual abuse.

Description : Good mood triggers?

Last Answer : Taking a walk through some woods especially near a lake or stream.

Description : I have a recurrent pain in my esophagus/sternum area. Could this be acid indigestion and what foods are triggers?

Last Answer : Does it happen at certain times? At night, laying down, working on something, etc.

Description : I have heard that the sense that triggers memories best is smell. Have you ever remembered something due to smell that you had otherwise forgotten? What does this say about how our memories work?

Last Answer : answer:Smells only come second nature to me, compared with music as an association. I can hear an old song and relate it to an eventful time in my past. Smells are good, but music does it for me. Good question. Buttermilk soap? Where can I buy it?

Description : Why do I seem to miss my loved ones that have passed at the most random times, with no recognizable triggers?

Last Answer : My father died back in 86 and I still at random times think of him and find myself missing him. It could be a time of year or something someone does that simply reminds me of him. Sometimes I sit ... when he passed away. I think its normal as long as its not bringing you into a deep deep depression.

Description : What triggers cell division?

Last Answer : Putting a mathematician in jail.

Description : What smell triggers a specific memory for you?

Last Answer : Certain girl’s perfume trigger memories of ex-girlfriends.

Description : What triggers a need in some people to have the last word?

Last Answer : I like the first word. ;) Great question

Description : What triggers blood clotting? -Biology

Last Answer : answer:

Description : When set to rinse, the pump hummed but did not release water. Only when we drained the water manually, the rinsing started but does not drain the water. When the pump is dismantled and tested outside the washing machine, the pump runs normally.

Last Answer : Need Answer

Description : When checking the pump outside the washing machine, it worked completely normally. But it does not drain the water during rinsing.

Last Answer : Need Answer

Description : What are some possible triggers of childhood obesity?

Last Answer : The most common causes of childhood obesity are genetic factors, lack of physical activity, unhealthy eating habits or a combination of 2 or more of these triggers. Occasionally there will be a medical ... triggers or causes. Even more rare are the triggers of a trauma or other psychological cause.

Description : Minimizing Pet Allergy Triggers?

Last Answer : When allergy season comes around during spring and summer, Allergies are often triggered in those who suffer when they are around pets. Here are some ways to keep pet allergies to a minimum during ... suffer from pet dander and it also includes a HEPA filter which can help with other allergens.