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

How to create Nano Banana 3D figurine step-by-step?

1. Launch Google Gemini or open Google AI Studio. 2. Select and upload the photo you want to convert. 3. Enter the following nanao banana 3...