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
How do you declare a constant?
What does a pl/sql package consist of?
Can we use pl sql in sql server?
Does truncate release storage space?
What is the best partition size for windows 10?
What has stored procedures in sql and how we can use it?
How to connect a sql*plus session to an oracle server?
What is nosql db?
Why use truncate instead of delete?
Can sql developer connect to db2?
How to use boolean type in select statement?
What is the difference between the repeatable read and serializable isolation levels? : Transact sql
How can we link a sql database to an existing android app?
Which join is like inner join?
How do you run a query?