Convert to SP !!!
Hi,
How to convert the following update statment as stored procedure thru Oracle SQL Developer :-
UPDATE TESTDTA.F4311
SET PDCNID = (SELECT A.PDCNID FROM TESTDTA.F564311 A
WHERE A.PDDOCO = '330001'
AND A.PDDCTO = 'O3'
AND A.PDLNID = 1000)
WHERE TESTDTA.F4311.PDDOCO = '330001'
AND TESTDTA.F4311.PDDCTO = 'O3'
AND TESTDTA.F4311.PDLNID = 1000;
Thanks in advance.
Regards,
RAM
How to convert the following update statment as stored procedure thru Oracle SQL Developer :-
UPDATE TESTDTA.F4311
SET PDCNID = (SELECT A.PDCNID FROM TESTDTA.F564311 A
WHERE A.PDDOCO = '330001'
AND A.PDDCTO = 'O3'
AND A.PDLNID = 1000)
WHERE TESTDTA.F4311.PDDOCO = '330001'
AND TESTDTA.F4311.PDDCTO = 'O3'
AND TESTDTA.F4311.PDLNID = 1000;
Thanks in advance.
Regards,
RAM
0