OraFAQ Forum: SQL & PL/SQL » convert to stored procedure

Home » SQL & PL/SQL » SQL & PL/SQL » convert to stored procedure

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

convert to stored procedure [message #8384]

Thu, 14 August 2003 11:34

Armani D
Messages: 19
Registered: February 2002

Junior Member

All,

Rather than having the excessive I/O that can be generated by the full table scan of customer_product (30 million rows) - what would be teh best way to write thsi as a stored procedure?

UPDATE PROD_ADMIN.CUSTOMER_PRODUCT SET CP_MP_ID = 787 WHERE
EXISTS ( SELECT 'x' FROM PROD_ADMIN.FANTASY_MISC WHERE FM_ID=CP_AP_ID AND FM_FL_ID=:1)

Report message to a moderator

Re: convert to stored procedure [message #8389 is a reply to message #8384]

Thu, 14 August 2003 13:16

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

Please do not crosspost - thanks. See reply in PL/SQL forum.

Report message to a moderator

Previous Topic:	Convert to PL/SQL
Next Topic:	Substitution in a select statement

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 07:15:36 CDT 2024