Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to Use Cursor variable in Where Statement
<wtistang_at_hotmail.com> a écrit dans le message de news: 1131718231.346267.313830_at_g47g2000cwa.googlegroups.com...
| Thanks for your response.
|
| The key is right. What I try to do here is to get data from one table
| and use the key field and value field to update the second table where
| is key matches. Do you have example how to do it in BULK operation?
|
| Thank you.
|
| Mike
|
PL/SQL User's Guide and Reference, chapter 5, "PL/SQL Collections and Records", sections "Reducing Loop Overhead for Collections with Bulk Binds" et seq: http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96624/05_colls.htm#23723
But why not doing it with just one SQL statement instead of using PL/SQL?
See update statement in SQL Reference:
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_108a.htm#2068178
Regards
Michel Cadot
Received on Fri Nov 11 2005 - 09:13:15 CST