Home » Other » General » Tools for automatically filling tables
Tools for automatically filling tables [message #289910] Wed, 26 December 2007 09:20 Go to next message
ChunCheng
Messages: 2
Registered: December 2007
Location: London
Junior Member
Hiya,

I am currently testing my new schema design. I would like to know there are tools that help to fill test data into tables automatically. Ideally filling a huge amount of data automatically for performance testing. It would be appreciated if there were any suggestions.

Cheers


ChunCheng
Re: Tools for automatically filling tables [message #289914 is a reply to message #289910] Wed, 26 December 2007 09:37 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL> select dbms_random.value(1,10) "NUMBER", dbms_random.string('A',10) "STRING"
  2  from dual
  3  connect by level <= 10
  4  /
    NUMBER STRING
---------- ----------
1.55845116 XrEPiHHant
4.86747382 RfYlgtCNxu
2.18417361 xUBhCzYQuO
3.10267016 IiZlcMXoYF
8.61457287 VrMCzIdRvf
5.13068812 YZGPHXBozB
1.81785275 qQByDibTpP
9.77087452 JXBpgQUvSn
7.44105924 OxgIeBXpdw
2.46703064 WqQkbbThup

10 rows selected.

Regards
Michel

[Updated on: Wed, 26 December 2007 09:38]

Report message to a moderator

Re: Tools for automatically filling tables [message #289944 is a reply to message #289914] Wed, 26 December 2007 16:55 Go to previous messageGo to next message
ChunCheng
Messages: 2
Registered: December 2007
Location: London
Junior Member
Hi there,

Thanks for your reply. That's really helpful. However, have you got any idea for any tools that is designed for filling the whole database, I mean not just one table, but also the tables it references.

Thanks again


ChunCheng
Re: Tools for automatically filling tables [message #290786 is a reply to message #289944] Mon, 31 December 2007 14:51 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No I don't know any such tool and I don't think it exists as filling tables with their relations is too closed of application that a general tool can't exist or is not profitable.

Regards
Michel
Previous Topic: Function to get GMT time
Next Topic: Procedure is not working
Goto Forum:
  


Current Time: Thu Mar 28 15:44:11 CDT 2024