- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Need script to fill up the database table
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-23-2002 02:17 PM
тАО05-23-2002 02:17 PM
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-23-2002 06:22 PM
тАО05-23-2002 06:22 PM
Re: Need script to fill up the database table
insert into
select * from < another table with same structure as your table>
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-24-2002 12:32 AM
тАО05-24-2002 12:32 AM
Re: Need script to fill up the database table
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;
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-24-2002 12:36 AM
тАО05-24-2002 12:36 AM
Re: Need script to fill up the database table
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-24-2002 04:50 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-24-2002 04:51 PM
тАО05-24-2002 04:51 PM
Re: Need script to fill up the database table
while numcount < 10000 loop
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-10-2002 10:42 AM
тАО06-10-2002 10:42 AM
Re: Need script to fill up the database table
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
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-10-2002 04:50 PM
тАО06-10-2002 04:50 PM
Re: Need script to fill up the database table
Brian