Interested to Buy Any Domain ? << Click Here >> for more details...
What are the differences between Database Trigger and
Integrity constraints ?
- 4 Answers
- 18049 Views
- I also Faced
- E-Mail Answers
Answer Posted / santu sarkar
1> A database trigger is written in PL/SQL. Integrity Constraints are CHECK Constraints, Not NULL, Unique key, primary key and foreign key.
2> Trigger will not affect the existing data. Constraint will affect the existing data.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is replication id?
Can a table contain multiple primary key’s?
Can we insert delete data in view?
What are different joins used in sql?
How will you distinguish a global variable with a local variable in pl/sql?
What is procedure and function?
Is it possible to pass parameters to triggers?
What is view explain with example?
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
Write the command to remove all players named sachin from the players table.
How do I edit a trigger in sql developer?
Can we use two order by clause in query?
what are the drivers in mysql? : Sql dba
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?
What is the file extension for sql database?
