Tested Daniel's MSSQL suggestions with Oracle 9, and had some good success - thanks Daniel, was something I was interested in also!
Example 2 - did not work as is (didn't try any variations - I'll check the
docs)
insert into footable( bar1,bar2)
values('#bar1[1]#', '#bar2[1]'),
('#bar1[1]#', '#bar2[1]'),
('#bar1[1]#', '#bar2[1]'),
.....
Example 1 - did work with variation - ** NOTE the 'FROM DUAL' clause
required
400 records inserted against slow dev server in 1.5 secs!!!!
** test script **
create table ER_Test
(
iId number(10,0),
vchText varchar2(100)
)
;
insert into ER_Test
( iID, vchText)
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 3, 'test 3' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
union all
select 1, 'test 1' FROM DUAL
union all
select 2, 'test 2' FROM DUAL
;
select * from ER_Test;
<<attachment: winmail.dat>>
