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

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

1 Answer

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.
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

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 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

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.

Give the sequence of execution of the various report triggers?

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

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

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.

Is it possible to insert comments into sql statements return in the data model editor?

Description : Is it possible to insert comments into sql statements return in the data model editor?

Last Answer : Yes

WHAT IS THE IMPLICATION OF DYNAMIC INSERT?

Description : WHAT IS THE IMPLICATION OF DYNAMIC INSERT?

Last Answer : code combinations from any form/window. If this feature is disabled, then the user cannot input new account code combinations from any window/form.   Oracle applications use a particular form ... can enter new account code combinations only through this form if Dynamic Insertion is disabled. 

What are the return values of functions SQLCODE and SQLERRM ? What is Pragma EXECPTION_INIT ? Explain the usage ?

Description : What are the return values of functions SQLCODE and SQLERRM ? What is Pragma EXECPTION_INIT ? Explain the usage ?

Last Answer : SQLCODE returns the latest code of the error that has occurred. SQLERRM returns the relevant error message of the SQLCODE.

What are the usage of SAVEPOINTS ?value in a session before accessing next value ?

Description : What are the usage of SAVEPOINTS ?value in a session before accessing next value ?

Last Answer : SAVEPOINTS are used to subdivide a transaction into smaller parts. It enables rolling back part of a transaction. Maximum of five save points are allowed.

What is a package ? What are the advantages of packages ? What is Pragma EXECPTION_INIT ? Explain the usage ?

Description : What is a package ? What are the advantages of packages ? What is Pragma EXECPTION_INIT ? Explain the usage ?

Last Answer : The PRAGMA EXECPTION_INIT tells the complier to associate an exception with an oracle error. To get an error message of a specific oracle error. e.g. PRAGMA EXCEPTION_INIT (exception name, oracle error number)

Explain the usage of WHERE CURRENT OF clause in cursors ?

Description : Explain the usage of WHERE CURRENT OF clause in cursors ?

Last Answer : WHERE CURRENT OF clause in an UPDATE,DELETE statement refers to the latest row fetched from a cursor. Database Triggers

Compare and contrast TRUNCATE and DELETE for a table.

Description : Compare and contrast TRUNCATE and DELETE for a table.

Last Answer : Both the truncate and delete command have the desired outcome of getting rid of all the rows in a table. The difference between the two is that the truncate command is a DDL operation and just ... other hand, is a DML operation, which will produce a rollback and thus take longer to complete.

What is difference between TRUNCATE & DELETE ?

Description : What is difference between TRUNCATE & DELETE ?

Last Answer : TRUNCATE commits after deleting entire table i.e., can not be rolled back. Database triggers do not fire on TRUNCATEDELETE allows the filtered deletion. Deleted records can be rolled back or committed.Database triggers fire on DELETE.

What is ON DELETE CASCADE ?

Description : What is ON DELETE CASCADE ?

Last Answer : When ON DELETE CASCADE is specified ORACLE maintains referential integrity by automatically removing dependent foreign key values if a referenced primary or unique key value is removed.

How will you delete duplicating rows from a base table?

Description : How will you delete duplicating rows from a base table?

Last Answer : delete from table_name where rowid not in (select max(rowid) from table group by duplicate_values_field_name); or delete duplicate_values_field_name dv from table_name ta where rowid

Differentiate between TRUNCATE and DELETE?

Description : Differentiate between TRUNCATE and DELETE?

Last Answer : TRUNCATE deletes much faster than DELETE TRUNCATE DELETE It is a DDL statement It is a DML statement It is a one way trip,cannot ROLLBACK One can Rollback Doesn't have selective features (where clause) Has Doesn't fire database triggers Does It requires disabling of referential constraints.

What are the different types of Delete details we can establish in Master-Details?

Description : What are the different types of Delete details we can establish in Master-Details?

Last Answer : Cascade Isolate Non-isolate

What are the different types of Delete details we can establish in Master-Details?

Description : What are the different types of Delete details we can establish in Master-Details?

Last Answer : Content canvas views Stacked canvas views Horizontal toolbar vertical toolbar.

What is the difference between DELETE and TRUNCATE statements?

Description : What is the difference between DELETE and TRUNCATE statements?

Last Answer : The DELETE command is used to remove rows from a table. A WHERE clause can be used to only remove some rows. If no WHERE condition is specified, all rows will be removed. After performing a DELETE operation ... be fired. As such, TRUCATE is faster and doesn't use as much undo space as a DELETE.

Which one is faster: DELETE or TRUNCATE?

Description : Which one is faster: DELETE or TRUNCATE?

Last Answer : TRUNCATE

What a SELECT FOR UPDATE cursor represent.?

Description : What a SELECT FOR UPDATE cursor represent.?

Last Answer : SELECT......FROM......FOR......UPDATE[OF column-reference][NOWAIT] The processing done in a fetch loop modifies the rows that have been retrieved by the cursor. A convenient way of ... the FOR UPDATE clause in the cursor declaration, WHERE CURRENT OF CLAUSE in an UPDATE or declaration statement.

If you update an assignment record multiple times in a single day, can you still track the record, if yes how?

Description : If you update an assignment record multiple times in a single day, can you still track the record, if yes how?

Last Answer : For some objects, such as assignments, more than one update per day is maintained by creating a physical record for each update. Such objects include an effective sequence number in each physical record to show the order in which updates made to an object on a single day were applied.

Insert, Delete, Page Up, Page Down, Home, Down keys located _____the arrow keys: a) Above b) Parallell c) Below d) None of These

Description : Insert, Delete, Page Up, Page Down, Home, Down keys located _____the arrow keys: a) Above b) Parallell c) Below d) None of These

Last Answer : a) Above

On a Windows PC, can you delete all those update files with the long code names and a dollar sign at the front?

Description : On a Windows PC, can you delete all those update files with the long code names and a dollar sign at the front?

Last Answer : Where are they located exactly?

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

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

Last Answer : People that get triggered.

Is this taking "triggers" a bit too far?

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.

What thoughts are guaranteed triggers of joyful feelings for you?

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. :-)

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

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.

Do you have any emotional triggers that you know of?

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

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

Good mood triggers?

Description : Good mood triggers?

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

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

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.

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?

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?

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

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.

What triggers cell division?

Description : What triggers cell division?

Last Answer : Putting a mathematician in jail.

What smell triggers a specific memory for you?

Description : What smell triggers a specific memory for you?

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

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

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

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