What are the differences between Database Trigger and
Integrity constraints ?
Answer Posted / guest
An integrity constraint defines a business rule for a table
column which automatically takes care by Oracle internally.
Intefrity Constraints are NOT NULL,UNIQUE,CHECK ,PRIMARY
KEY,FOREIGN KEY.
A database trigger is a procedure written in PL/SQL and
Will run implicitly when data is modified or when some user
or system actions occur.Triggers are database objects which
gets stored in database and get fires when INSERT or UPDATE
statement attempts to violate the integrity rule, Oracle
must roll back the statement and return an error if trigger
exists.Database triggers are BEFOR/AFTER/{BEFORE|AFTER}
{row|statement etc.
Is This Answer Correct ? | 11 Yes | 3 No |
Post New Answer View All Answers
Can a trigger call a stored procedure?
Show code of a cursor for loop.
What are the most important characteristics of pl/sql?
What is count * in sql?
Which one is better subquery or joins?
Mention what is the use of function "module procedure" in pl/sql?
What pl/sql package consists of?
Is progress software supports to ( pl/sql )?
How do I partition a table in sql?
Why we use pl sql?
Mention what are the benefits of pl/sql packages?
What is the difference between syntax error and runtime error?
How can you create an empty table from an existing table?
What is the difference between partitioning and sharding?
How do you sort in sql?