Answer / kumar jabu

Constraints implements specific conduct or rules on table column like it determines whether field data should be unique,not null ..
But triiger implements rules on systems or application event.
whenever dml occurs that implemented rules been fired.

Answer / naga sindhuri

Triggers not apply for existing rows but constraints can
apply for existing rows.

Answer / 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.

what are the advantages of using stored procedures? : Sql dba

0 Answers  

---

What sql database should I use?

0 Answers  

---

Can a varchar be a primary key?

0 Answers  

---

Does normalization improve performance?

0 Answers  

---

how can we write a column values horizontal by using sql stmt; ex: select name from table_name;(actual output) a b c d require output is a b c d

5 Answers   Honeywell, Interact,

---

What are sql objects?

0 Answers  

---

Explain two virtual tables available at the time of database trigger execution.

1 Answers  

---

What is oracle sql developer?

0 Answers  

---

How to return more than one value from a function?

11 Answers   Satyam,

---

diff b/w function and procedure?

9 Answers   iFlex,

---

What is a natural join sql?

0 Answers  

---

What are the different sql languages?

0 Answers  

---