Which Of The Following Syntax Is Correct Way To Create A #591
Which of the following syntax is correct way to create a trigger in PL/SQL?
This multiple choice question (MCQ) is related to the book/course
gs gs115 Structured Query Language.
It can also be found in
gs gs115 PL/SQL Records, Exceptions and Triggers - PL/SQL Triggers - Quiz No.1.
Which of the following syntax is correct way to create a trigger in PL/SQL?
CREATE [OR REPLACE] TRIGGER trigger_name {BEFORE | AFTER | INSTEAD OF} {INSERT [OR] | UPDATE [OR] | DELETE} [OF table_name] ON row_name [REFERENCING OLD AS o NEW AS n] [FOR EACH ROW] WHEN (condition)CREATE [OR REPLACE] TRIGGER {BEFORE | AFTER | INSTEAD OF} {INSERT [OR] | UPDATE [OR] | DELETE} [OF column_name] table_name [REFERENCING OLD AS o NEW AS n] [FOR EACH ROW] WHEN (condition) CREATE [OR REPLACE] TRIGGER trigger_name {BEFORE | AFTER | INSTEAD OF} {INSERT [OR] | UPDATE [OR] | DELETE} [OF column_name] ON table_name [REFERENCING OLD AS o NEW AS n] [FOR EACH ROW] WHEN (condition)CREATE [OR REPLACE] trigger_name {BEFORE | AFTER | INSTEAD OF} {INSERT [OR] | UPDATE [OR] | DELETE} [OF column_name] ON table_name [REFERENCING OLD AS o NEW AS n] [FOR EACH ROW] (condition)
