Answer Posted / shekar
Triggers: It checks the condition and Performs some action
eg: it checks and fires before or after insert or update
or delete
Constriants: it checks the condition
eg: suppose NotNull constraint.It jst doesn't allow null
values.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain the types of joins in sql?
What is a table partition?
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
What are the sql versions?
what are properties of a transaction? : Sql dba
What is the purpose of using pl/sql?
What is the difference between nvl function, ifnull function, and isnull function?
What are sql triggers used for?
How to return multiple rows from the stored procedure?
Can a trigger call a stored procedure?
How do you run a query?
How do sql databases work?
Is natural join and inner join same?
Mention what does plv msg allows you to do?
