Please see the code below....What does it do, and when is it triggered ?

Question

CREATE TRIGGER triggerinsert
ON PERSONAL
FOR INSERT
AS
BEGIN
Print ('AFTER Trigger [triggerinsert] - Trigger Executed!!')
END

Answer 1

This looks like PL/SQL.



It has been a while - but I think this is triggered on the insert into a table (in this case - table PERSONAL). This is just the create of the trigger. And it would just write out to the screen - "Trigger Executed".



Hope that helps!

Answer 2

When ever a new row of data is inserted into the PERSONAL table in your Oracle database, this trigger is executed displaying the message "Trigger Executed' in your PL/SQL editor.



If you are calling this from a front end like VB the return value after execution of this trigger will be a string "Trigger Executed'



This will triggered when a new row is interted in to the PERSONAL table.

Answer 3

This code will print (to stdout) the phrase "AFTER Trigger [triggerinsert] - Trigger Executed!!" when ever a row is inserted into the table PERSONAL.



Also it will not execute on update nor delete.

Answer 4

What language is it in?



Either way, I'm pretty sure it's going to do absolutely nothing. Basically ,it's just going to write somewhere 'Trigger Executed'.



..