SQL Language (MOSC)

MOSC Banner

Convert to SP !!!

edited Jul 4, 2013 10:31PM in SQL Language (MOSC) 6 commentsAnswered ✓
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center