SQL TO INCREMENT EXISTING COLUMN VALUE BASED ON PARENT AND CHILD ID

DECLARE
i number:=0;
BEGIN
FOR REC1 IN (SELECT * FROM TBLMCSVDRIVER)
LOOP
i := 0;

FOR REC2 IN (SELECT * FROM TBLMCSVDRIVERFIELDMAP WHERE CSVDRIVERID = REC1.CSVDRIVERID order by fieldmapid)
LOOP
i:=i+1;

update TBLMCSVDRIVERFIELDMAP set ORDERNUMBER = i where FIELDMAPID = REC2.FIELDMAPID AND CSVDRIVERID = REC1.CSVDRIVERID;
END LOOP;
END LOOP;
END;
/

Advertisements

About rajkirpal

i am a software engineer. and i have decent knowledge about java technologies like ANDROID, Servlet, Jsp, Struts, Hibernet, Spring, J2ME, Java Script, Ajax, JQuery, CSS. Further i am Preparing Easy understandable materials/documents upon the same java technologies and developing project in core java , advanced java and j2me , ANDROID as per the requirements Also designing the web sites and logos Thank You.
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s