Pages

Subscribe:

Tuesday, 1 August 2017

Loop in oracle

BEGIN
For i in (select id, name, mobile from testtable)
LOOP
Update mappingtesttable set name = i.name,mobile_no=i.mobile where fkid = i.id;
END LOOP;
END;

0 comments:

Post a Comment