Answer / ganesh

Trigger: A set of pl/sql statments that are stored
permenantly in the database it activates when ever the DML
operations performed on the table.

constraints: Set of predefind rules are applied on table
column while creating the table or after creating the
table. and automatically performed when DML statemets are
performed by user.

the main differece between the two is
trigger will not effect the existing rows(it will effects
only new rows after creating a trigger on a table),
where as in the constraints it will effect the existing
rows also.

Answer / nilkantha

I can't find the answer.Pls Give me the right answer

Explain database partitioning.

0 Answers  

---

Clipper / DBF error

1 Answers  

---

Which Statement would you use to remove the EMPLOYEE_Id_PK PRIMARY KEY constraint and all depending constraints from the EMPLOYEE table?

0 Answers   3i Infotech,

---

what is rcp,if rcp disabled what happen?

0 Answers   Systel,

---

WHAT IS NEED BY METION DATFMT AND TIMFMT IN H-SEPICITION IN RPGLE?

0 Answers  

---

Is it possible to update AS400 database record while reading it with no lock

1 Answers  

---

Hi, I want do a course in DWH Informatica Administrator and Abinito Administrator please tell me some institute in chennai and i am searching for a job,so please help me and my mail id : satty_rh@yahoo.co.in Thanks, Kumar

0 Answers  

---

What is ole db ado?

0 Answers  

---

Define stored procedure?

0 Answers  

---

Explain database partitioning. What is its importance?

0 Answers  

---

What is database schema name?

0 Answers  

---

What is aws documentdb?

0 Answers  

---