To avoid insertions using merge in oracle 9.2.0.8.0 release. (merged) [message #384220] |
Mon, 02 February 2009 22:47  |
ind9
Messages: 65 Registered: January 2009
|
Member |
|
|
Hi,
I am using oracle 9.2.0.8.0 release.
Begin
Merge Into Emp2 e2
Using emp e
On (E.Emp_Id = E2.Emp_ID)
When Matched Then
Update Set
E2.Modified_DATE =Sysdate
When Not Matched Then --avoid Insertions
Insert (Emp_ID)
Values(1/0);--To avoid insertions i used this
Exception
When Others Then
Dbms_Output.Put_Line(Sqlerrm);
I am getting zero divisor error.
Here when conditions matches i want to update modified_date.
When not matched i do not want to insert the values.
I cannot use normal update statement since i have almost all 30000 records in emp2 table.
Kindly suggest me how can i avoid insert operations in merge.
|
|
|
|
|
|
|
|
|
|
|
|