topic Re: Need script to fill up the database table in Operating System - HP-UX

Need script to fill up the database table

Deanna Tran — Thu, 23 May 2002 21:17:48 GMT

Does any one have any sample script that would help me to fill up the database table ?

Re: Need script to fill up the database table

Printaporn_1 — Fri, 24 May 2002 01:22:47 GMT

usr SQL:
insert into
select * from < another table with same structure as your table>

Re: Need script to fill up the database table

H.Merijn Brand (procura — Fri, 24 May 2002 07:32:27 GMT

#!/opt/perl/bin/perl -w

use DBI;

my $dbh = DBI->connect (.....);
my $sth = $dbh->prepare (q;
insert into table values (?, ?, ?, ?););
foreach (0 .. 1_000_000) {
$sth->execute ($_, "$_", 1, "A");
}
$sth->finish;
$dbh->commit;

Re: Need script to fill up the database table

Victor Geere — Fri, 24 May 2002 07:36:51 GMT

create one record in the table that you want to fill up.

then

insert into TheTable (select * from TheTable);

run this a couple of times and you will have
1,2,4,8,16,32,64,128... etc. records in the table after each run.

Re: Need script to fill up the database table

Brian Crabtree — Fri, 24 May 2002 23:50:38 GMT

create table tmptable (currnum number, junkinfo varchar2(10));

declare
numcount number;
begin
numcount:=0
while currnum < 10000 loop
numcount:=numcount+1;
insert into tmptable values (numcount,'ABCDEFG');
end loop;
end;
/

Re: Need script to fill up the database table

Brian Crabtree — Fri, 24 May 2002 23:51:39 GMT

Excuse me, that should read:

while numcount < 10000 loop

Re: Need script to fill up the database table

Deanna Tran — Mon, 10 Jun 2002 17:42:03 GMT

HI brian,
I used it your script , but when i try to run it, it gives me error...actually i modified the script to have it run indefinitely..and this is the error that i got

here is the script
declare
numcount number;
begin
numcount:=1800
while (numcount-1) < 100000 loop
numcount:=numcount+1;
insert into employees value(numcount,'dfkjebkg','dljlkhgoi',6789.34,623495098);
end loop;
end;
/

while (numcount-1) < 100000 loop
*
ERROR at line 5:
ORA-06550: line 5, column 1:
PLS-00103: Encountered the symbol "WHILE" when expecting one of the following:
* & = - + ; < / > at in is mod not rem
<> or != or ~= >= <= <> and or like between ||
The symbol "*" was substituted for "WHILE" to continue.
ORA-06550: line 5, column 29:
PLS-00103: Encountered the symbol "LOOP" when expecting one of the following:
* & - + ; / at mod rem and or ||
ORA-06550: line 7, column 1:
PLS-00103: Encountered the symbol "INSERT" when expecting one of the following:
begin function package pragma procedure subtype type use

Re: Need script to fill up the database table

Brian Crabtree — Mon, 10 Jun 2002 23:50:27 GMT

It looks like you need a ";" on the "numcount:=1800". It is expecting that, and it is finding the "while". Also, you will not want to run this indefinately, as there is a finite amount of rollback on the database. You will want to either terminate the program, or put another variable in that will perform a commit after a set number of records.

Brian