Hi,

 Does any one have an idea on MERGE command in oracle.

Thanks
Uma

hi uma

check this out

http://www.dba-oracle.com/oracle_tips_rittman_merge.htm

MERGE INTO copy_emp c
  USING employees e
  ON (c.empid=e.empid)
WHEN MATCHED THEN
  UPDATE SET
    c.firstname=e.firstname,
    c.lastname=e.lastname,
WHEN NOT MATCHED THEN
  INSERT VALUES(e.empid,e.firstname,e.lastname)

Subhendu De
[email protected]
Software Developer
New Delhi, India

Hi,

 Thanks for the tips.
 I have incorporated a different solution -
INSERT INTO TABLE_NAME (ID, EFF_DT, END_DT)
(SELECT ?, ?, ? FROM DUAL WHERE NOT EXISTS
(SELECT EFF_DT, FROM TABLE_NAME WHERE EFF_DT = ?))