Hi,

i try to run some benchmarks which i wrote for Oracle.

I have to fill a table with some data:

Oracle version is:

create table benchtest (
operator varchar (39),
line integer
text varchar2(2000)
)

begin
for i on 1..50000 loop
insert into benchtest(operator, line, text)
values(user, i, lpad(to_char(i), 200));
end loop;
end;

Any ideas?

kind regards,

Toni

--
Posen fuer Anfaenger: http://www.w-klch.med.uni-muenchen.de/dischner

On 10 Dec, 11:48, "A. Dischner" <anton.disch...@med.uni-muenchen.de>
wrote:
> Hi,
>
> i try to run some benchmarks which i wrote for Oracle.
>
> I have to fill a table with some data:
>
> Oracle version is:
>
> create table benchtest (
> operator varchar (39),
> line integer
> text varchar2(2000)
> )
>
> begin
> for i on 1..50000 loop
> insert into benchtest(operator, line, text)
> values(user, i, lpad(to_char(i), 200));
> end loop;
> end;
>
> Any ideas?
>
> kind regards,
>
> Toni
>
> --
> Posen fuer Anfaenger:http://www.w-klch.med.uni-muenchen.de/dischner

http://datacharmer.blogspot.com/2006...s-quickly.html