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.

Is oracel sql developer written in java?

0 Answers  

---

what is the use of friend function? : Sql dba

0 Answers  

---

There is a table, In one column it has implemented a index, but the index is disturbed by the regular dml statements.. but still we need to keep the index. how it is possible?

1 Answers   Cognizant,

---

What is a native sql query?

0 Answers  

---

Are sql views compiled?

1 Answers  

---

What are the different parts of a package?

0 Answers  

---

What are different clauses used in sql?

0 Answers  

---

Define commit?

0 Answers  

---

Is left join faster than inner join?

0 Answers  

---

What can you do with pl sql?

0 Answers  

---

Is oracle sql free?

0 Answers  

---

How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

0 Answers   MCN Solutions,

---