Thursday, January 30, 2020

Load bulk data using Oracle Stored Procedure bulk INSERT example using loop



Oracle Stored Procedure bulk INSERT example using loop


SQL> create table t ( x int, y varchar2(500) );

Table created.

Elapsed: 00:00:00.08
SQL> begin
    for i in 1 .. 100000
    loop
        insert into t values ( i, 'xxxxxxxxxxxxx' );
    end loop;
    commit;
end;
/  2    3    4    5    6    7    8

PL/SQL procedure successfully completed.

Elapsed: 00:00:03.70
SQL>

1 comment:

  1. Your Affiliate Profit Machine is ready -

    And making money with it is as easy as 1, 2, 3!

    Here are the steps to make it work...

    STEP 1. Choose affiliate products you want to promote
    STEP 2. Add some PUSH BUTTON TRAFFIC (it LITERALLY takes JUST 2 minutes)
    STEP 3. See how the system grow your list and sell your affiliate products on it's own!

    Are you ready to make money automatically??

    Click here to start running the system

    ReplyDelete

About the Author : Anurag Pandey | Database cloud Architect | Oracle | SQL Server | PostgreSQL | AI and Data Platform Enthusiast

Anurag Pandey is a Database Architect with expertise in Oracle, PostgreSQL, SQL Server, Linux, and enterprise database platforms and specializes in database architecture, performance tuning, high availability, disaster recovery, cloud modernization, and operational excellence. With extensive experience in enterprise-scale environments, Anurag is passionate about leveraging AI, automation, and modern data platforms to improve reliability, scalability, and business outcomes. He actively contributes to technical communities through knowledge sharing, architecture guidance, and thought leadership in database and data engineering domains.

Follow more articles at

Visit Blog

Oracle 19c to PostgreSQL 15 Migration: Step-by-Step Production Guide (Ora2Pg + DMS)

Production-oriented migration approach for a complex Oracle 19c to PostgreSQL 15 workload , covering assessment, schema and code conversion,...