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: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
./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: 64132
Registered: March 2007
Location: Nanterre, France, http://...
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: Wed Dec 07 22:08:46 CST 2016

Total time taken to generate the page: 0.06717 seconds