Re: oracle procedure
Posted by:
m a
Date: November 04, 2014 12:17AM
if i send the procedure can you please write it down according to mysql syntax ?,i will be grateful to you.
the oracle procedure is as shown below,how to write the same procedure for mysql
create PROCEDURE xxc
IS
CURSOR c1
IS
SELECT dg_no, ruc, codes, dgtype, expdt
FROM xx.test a
WHERE active = 'Yes';
BEGIN
FOR c2 IN c1
LOOP
UPDATE xx.xxc
SET (dg_no, ruc, codes, dgtype, expdt) =
(SELECT dg_no, ruc, codes, dgtype,
expdt
FROM xx.test a
WHERE active = 'Yes' AND dg_no = c2.dg_no)
WHERE dg_no = c2.dg_no AND active_user = 'Yes';
END LOOP;
END;
END;
Subject
Views
Written By
Posted
2158
November 03, 2014 06:33AM
1041
November 03, 2014 10:05AM
Re: oracle procedure
1169
November 04, 2014 12:17AM
1038
November 04, 2014 12:55PM
1029
November 04, 2014 09:59PM
1127
November 05, 2014 07:10AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.