Home » SQL & PL/SQL » SQL & PL/SQL » Populating a table using a cursor
Populating a table using a cursor [message #38140] Mon, 25 March 2002 02:35 Go to next message
Greg Horton
Messages: 37
Registered: February 2002
Member
I have populated a CURSOR and would like to transfer the data held in this CURSOR to an empty Oracle table.

Can any one advise?

Thanks.

Report message to a moderator

Re: Populating a table using a cursor [message #38142 is a reply to message #38140] Mon, 25 March 2002 04:51 Go to previous message
Kalpa Shah
Messages: 3
Registered: February 2002
Junior Member
Cursor is a good idea.
The other thing you could do is use collections. The PL/SQL reserved word is BULK COLLECT.
What BULK COLLECT does is it fetches all the records at a time unlike cursor which fetches one record at a time. This improves performace noticablely.

What exactly did you mean when you said can anyone advise? do you want a sample code or were you asking if this is the best way to go.

Report message to a moderator

Previous Topic: LOBs
Next Topic: Select ALL privileges of a particular user
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 23 20:04:01 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.