Sql fetch cursors

August 13, 2008

DECLARE
slip_Update CURSOR FOR
SELECT * FROM SlipsTEST, SlipdetailsTEST
WHERE SlipsTEST.SlipIdOld = SlipdetailsTEST.SlipIdOld
FOR UPDATE;
BEGIN
OPEN slip_Update;
FOR slip_Update IN slip_Update
LOOP
UPDATE SlipdetailsTEST
SET SlipdetailsTEST.SNO = SlipsTEST.SNO
WHERE CURRENT OF slip_Update;
END LOOP;
CLOSE slip_Update;
END;

Entry Filed under: Database. Tags: , , , , , , , , , , , , , , , , .


Archives

Other

Categories

 

August 2008
M T W T F S S
« Jul   Sep »
 123
45678910
11121314151617
18192021222324
25262728293031

Tags