Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between trigger and constraint?
- 3 Answers
- 8865 Views
- HSBC, I also Faced
- E-Mail Answers
Answer Posted / milind chopde
1) Constraints can be used for validation but trigger can be used for complex validation and auditing purpose.
2) Trigger is database object but constraint not.
3) Trigger can be fired on DDL commands but constraints are created or altered using DDL commands.
4) Trigger can be fired on particular event like before/after DML but constraint always check before any data insert or update to table.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
how to dump a table to a file with 'mysqldump'? : Sql dba
Is it possible to read/write files to-and-from PL/SQL?
What is natural join in sql?
How to connect a sql*plus session to an oracle server?
what is myisam? : Sql dba
What is bulk collect in pl sql?
who introduced sql?
What jobs use sql?
What is aggregate function in sql?
How do I write a cron which will run a sql query and mail the results to agroup?
What is cursor and why it is required?
How do I clear the screen in sql plus?
Can we alter stored procedure?
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
How to display Row Number with Records in Oracle SQL Plus?
