Answer Posted / dhanashree
Running block of code or the querry having opposite
condition placed in the trigger.When the condition gets
false then the trigger gets called avoiding particular
action such as Update,Delete,Insert depending on the
trigger type.The trigger output is in form of Error massage
used in trigger itself.
| Is This Answer Correct ? | 8 Yes | 5 No |
Post New Answer View All Answers
how to convert dates to character strings? : Sql dba
What is difference between stored function and application function?
What is using in sql?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
How do I create a sql script?
What is trigger and stored procedure in sql?
How many types of triggers exist in pl/sql?
What is sql query optimization?
Does a primary key have to be a number?
How will you distinguish a global variable with a local variable in pl/sql?
does sql support programming? : Sql dba
What is the difference between the repeatable read and serializable isolation levels? : Transact sql
What does desc stand for?
How to display the records between two range in Oracle SQL Plus?
What does partition by mean in sql?