db wOrLd

If you can't explain it simply, you don't understand it well enough. Albert Einstein

Saturday, January 20, 2007

Mini data generator

Will Hitchcock proposed a PL/SQL approach for generating the 1000 rows:

declare
i number := 1;
begin
for i in 0..999 loop
insert into pivot values (i);
end loop;
end;
/
Posted by Darek at 16:57

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2011 (1)
    • ►  March (1)
  • ►  2010 (3)
    • ►  March (2)
    • ►  February (1)
  • ►  2009 (5)
    • ►  November (1)
    • ►  July (1)
    • ►  April (2)
    • ►  March (1)
  • ►  2008 (8)
    • ►  December (2)
    • ►  November (1)
    • ►  September (1)
    • ►  June (1)
    • ►  April (2)
    • ►  January (1)
  • ▼  2007 (39)
    • ►  December (4)
    • ►  November (7)
    • ►  October (5)
    • ►  September (4)
    • ►  August (2)
    • ►  July (9)
    • ►  May (1)
    • ►  February (3)
    • ▼  January (4)
      • Mini data generator
      • Oracle Menu (om) is only a shell script.
      • Drupal + Oracle: Inside the OraDrup Project
      • Oracle RAC 10g on Oracle Enterprise Linux Using VM...
  • ►  2006 (38)
    • ►  December (5)
    • ►  November (3)
    • ►  October (1)
    • ►  August (2)
    • ►  July (4)
    • ►  June (10)
    • ►  May (8)
    • ►  April (5)

Link List

  • RSS feed (myPage)
  • db indexes - all about indexes
  • Oracle 10g Express Ed.
  • IBM DB2 Express-C
Add to Technorati Favorites

Labels

  • 10g (1)
  • 11g (6)
  • apex (10)
  • CMS (1)
  • Data Mining (1)
  • database (1)
  • DB2 (1)
  • Drupal (1)
  • e-r diagram (2)
  • Grid (1)
  • Linux (2)
  • Oracle (18)
  • Oracle VM (1)
  • RAC (3)
  • security (1)
  • spatial (1)
  • sql (2)
  • tools (2)
  • VirtualBox (1)
  • VMware (1)
  • xe (8)
Awesome Inc. theme. Powered by Blogger.