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

query to Compare data of two tables between two different Databases(Oracle and SQL Server) Eg., Source Database: Oracle Table: Employee Target Database : SQL Server Table : emp

0 Answers   Verizon,

---

How does database replication work?

0 Answers  

---

how to reject duplicates in source sequential file and if by filter option then where is that filter option in the sequential file.

0 Answers  

---

Does facebook use graph database?

0 Answers  

---

I have single column in a file. Input 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15 my output is file 1 have 1,2,3,10,11,12 file 2 have 4,5,6,13,14,15 and file 3 have 7,8,9 how is it possible in datastage

0 Answers   IBM,

---

---

what is transaction state, buffer management, shadow paging

0 Answers  

---

what is tkprof tool and how it is used???

0 Answers   Genpact,

---

How to do Data size testing? Who does this testing (Developer or tester)?

0 Answers  

---

What do you mean by database?

0 Answers  

---

hai if any one having any project sample table structure please froward to my mail id tauseefwst@yahoo.com

0 Answers   HP,

---

When should you not use firebase?

0 Answers  

---

What do you mean by foreign key and primary key?

0 Answers   Zensar,

---