stored procedure
body,html { background:transparent; margin: 0;}body{ top:0px; left:0px; right:0px; font:400 13px Myriad, Arial, Helvetica, clean, sans-serif; padding: 5px; background-color: white; min-height:1em; line-height:1.0}p{ margin: 1em 0; }li > ul:-moz-first-node, li > ol:-moz-first-node{ padding-top: 1.2em; } li{ min-height:1.2em; }.dijitEditorXml { color:#5a038c; font-weight:bold;}
body { padding-bottom: 5px; }
I need to write a stored procedure to combine two sql queries for processing purpose.
SELECT * FROM TICCRM.TTIITM001100_COPY WHERE REFLAG = 0 AND ROWNUM < 1001 FOR UPDATE;
UPDATE (SELECT * FROM TICCRM.TTIITM001100_COPY WHERE REFLAG = 0) SET REFLAG = NULL WHERE ROWNUM < 1001;
The first one should return 1k records to me and the second one marks those records as processed.
0