Home » SQL & PL/SQL » SQL & PL/SQL » How to insert many rows?
How to insert many rows? [message #1059] Tue, 26 March 2002 09:22 Go to next message
George
Messages: 68
Registered: April 2001
Member
Hi,

I need to insert many records every day, the records come from clients and our apps translate them into the data required in database.

What is the better way to do this, I am thinking about stored procedure, but how do I pass so much data into the sp as a parameter? Or anybody have better ways to do this to improve performance and reduce network traffic?

Thanks

Report message to a moderator

Re: How to insert many rows? [message #1090 is a reply to message #1059] Sun, 31 March 2002 17:49 Go to previous message
Cindy
Messages: 88
Registered: November 1999
Member
You could try using sqldlr (SQL LOADER), if the data are in flat file after translation process.

Report message to a moderator

Previous Topic: Cursors
Next Topic: Re: buffer over flows
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 00:33:23 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.