Dinesh Kumar, March 08, 2017 - 6:28 am UTC
Hi Connor,
Thanks for the resolution but i have to use any of the tool like SQL Developer or PL/SQL Developer.
Please suggest me a resolution which will work in any of the above tool.
RDB.
March 09, 2017 - 1:51 am UTC
The example I gave will work fine with SQL Developer
If you are sending this across a network, then less trips will also help, so you could batch up statements into blocks, eg
insert into t values (...);
insert into t values (...);
insert into t values (...);
insert into t values (...);
insert into t values (...);
insert into t values (...);
insert into t values (...);
insert into t values (...);
insert into t values (...);
becomes
begin
insert into t values (...);
insert into t values (...);
insert into t values (...);
insert into t values (...);
end;
/
begin
insert into t values (...);
insert into t values (...);
insert into t values (...);
insert into t values (...);
end;
/
Just dont make them too large