Home » Infrastructure » Unix » Script to create data for testing (Unix)
Script to create data for testing [message #407719] Thu, 11 June 2009 05:03 Go to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member
Hi,

can any one please let me know how to write a PL/SQL or shell script to create data fro testing?

( for eg: I have executed one query in the DEVELOPMENT environment. In dev. it doesn't have any data. But I want to create some data for testing purpose by using the script.In integration we have data. But some times database link was not created between these two environments. that time I am facing a problem for doing testing.

so for this I want to write a PL/SQL or Shell script to create data .)

please give me the solution for this.


Thank you,

SNN.
Re: Script to create data for testing [message #407728 is a reply to message #407719] Thu, 11 June 2009 05:45 Go to previous messageGo to next message
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
/forum/fa/449/0

Shell script:

1) start it with #!/usr/bin/bash
2) fill in the commands you need
3) fix any syntax errors

PL/SQL - Script:

1) write a declare/begin/end block
2) fill in the commands you need
3) fix any syntax errors
Re: Script to create data for testing [message #407738 is a reply to message #407728] Thu, 11 June 2009 06:16 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
In addition, use dbms_random.

Regards
Michel
Previous Topic: Oracle 9i silent install on aix 5.3
Next Topic: Using ps -ef |grep LOCAL
Goto Forum:
  


Current Time: Tue Dec 03 14:00:51 CST 2024