You must Sign In to post a response.
  • Category: ASP.NET

    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 also

    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]

  • #765733
    Hi Prasad

    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.


Sign In to post your comments