performance with INSERT/EXCEPTION/UPDATE pattern

[abhaysk]

Originally posted by chrisrlong
But the other way around, of course.
- Chris

Chris :
I didnt get what you wanted to tell, but lemme explain what I thought

SQL%ROWCOUNT is not at all needed...(yes if using cursors, but not needed in bulk loads)

jus see below eg

Insert into X select %Attribute_List% From Y 
Where Not Exists (Select 1 From X Where PK_Of_X=Cols_Of_Y ( Or Sub Query ) )
;

Update X Set (COLx1,COLx2,...) = (Select %Attribute_List% From Y Where Cols_Of_Y ( Or Sub Query )=PK_Of_X)
Where Exists
(Select 1 from Y Where Cols_Of_Y ( Or Sub Query )=PK_Of_X)
;

Abhay.