Rate this post by selecting a number. 1 is the worst and 5 is the best.

Author Message   Blazewada Mudiripoyina Bewarse Username: Blazewada Post Number: 24704 Registered: 08-2008 Posted From: 183.90.116.212 Rating: N/A Votes: 0 Posted on Thursday, October 15, 2015 - 10:16 am:    Proofdada: Krishna_jilla: MERGE TableX A using (SELECT ID as 'UUID' FROM DUAL) AS B ON A.ID = B.ID WHEN MATCHED THEN UPDATE SET A.FirstName = 'xx', A.LastName = 'yy' WHEN NOT MATCHED THEN INSERT VALUES (B.ID, 'xx', 'yy'); tittoddu ed try chesaa.