Bulk update available in oracle
Is there any method for using bulk update for oracle ?? Im using oraclebulkcopy for INsert. I would like to know for bulk update alsoAlso if record already exist , I would like to use bulkupdate else bulk insert
You must Sign In to post a response.
Category: ASP.NET
Also if record already exist , I would like to use bulkupdate else bulk insert
#765726
I think BULK COLLECT and FORALL will help you in this case.
BULK COLLECT: SELECT statements that retrieve multiple rows with a single fetch, improving the speed of data retrieval
FORALL: INSERTs, UPDATEs, and DELETEs that use collections to change multiple rows of data very quickly
OR
The two most common forms of Bulk Updates are:
1.Update (almost) every row in the table. This is common when applying data patches and adding new columns.
2.Updating a small proportion of rows in a very large table.
checkout below link for more details
http://www.oracle.com/technetwork/issue-archive/2012/12-sep/o52plsql-1709862.html
http://www.orafaq.com/node/2450
Thanks
Koolprasd2003
Editor, DotNetSpider MVM
Microsoft MVP 2014 [ASP.NET/IIS]
BULK COLLECT: SELECT statements that retrieve multiple rows with a single fetch, improving the speed of data retrieval
FORALL: INSERTs, UPDATEs, and DELETEs that use collections to change multiple rows of data very quickly
OR
The two most common forms of Bulk Updates are:
1.Update (almost) every row in the table. This is common when applying data patches and adding new columns.
2.Updating a small proportion of rows in a very large table.
checkout below link for more details
http://www.oracle.com/technetwork/issue-archive/2012/12-sep/o52plsql-1709862.html
http://www.orafaq.com/node/2450
Thanks
Koolprasd2003
Editor, DotNetSpider MVM
Microsoft MVP 2014 [ASP.NET/IIS]
#765733
Hi Prasad
It will be helpful if in C#code ... No idea of PL/sql or sql
It will be helpful if in C#code ... No idea of PL/sql or sql
#765740
hi
bulk sql means
you can go through in cursor in sql server thats better to insert huge records.
Name : Dotnet Developer-2015
Email Id : kumaraspcode2009@gmail.com
'Not by might nor by power, but by my Spirit,' says the LORD Almighty.
bulk sql means
you can go through in cursor in sql server thats better to insert huge records.
Name : Dotnet Developer-2015
Email Id : kumaraspcode2009@gmail.com
'Not by might nor by power, but by my Spirit,' says the LORD Almighty.
Return to Return to Discussion Forum