Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: need code for Bulk inserts
<paulhux174_at_hotmail.com> a écrit dans le message de news: 1141191254.626846.187830_at_z34g2000cwc.googlegroups.com...
| Hi,
| This code is far too slow. Can some show me some code to speed it up.
| Many thanks.
|
| -- PL SQL CODE
| --------------------------------------------------------------------------------
| OPEN val_cur;
| -- about 100,000 records
| LOOP
| FETCH val_cur
| INTO c1rec;
|
| EXIT WHEN val_cur%NOTFOUND ;
| parent_parent_zuidbook := getparent (p_uid =>
| c1rec.uidvalue); -- function call gets an ID number.
|
| IF parent_zuidchh IS NOT NULL
| THEN
| UPDATE zbook a
| SET a.zuidparent = c1rec.zuidbook
| WHERE a.zuidbook = parent_zuidbook;
| UPDATE zbook a
| SET a.ztype = 'U'
| WHERE a.zuidbook = c1rec.zuidbook;
| ELSE
| UPDATE zbook a
| SET a.ztype = 'I'
| WHERE a.zuidbook = c1rec.zuidbook;
| END IF;
| END LOOP;
| CLOSE val_cur;
|
| --------------------------------------------------------------------------------
|
What is your Oracle version?
What is getparent code?
Regards
Michel Cadot
Received on Tue Feb 28 2006 - 23:50:58 CST