OraFAQ Forum: Unix » Script to create data for testing

Home » Infrastructure » Unix » Script to create data for testing (Unix)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Script to create data for testing [message #407719]

Thu, 11 June 2009 05:03

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.

Report message to a moderator

Re: Script to create data for testing [message #407728 is a reply to message #407719]

Thu, 11 June 2009 05:45

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

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

Report message to a moderator

Re: Script to create data for testing [message #407738 is a reply to message #407728]

Thu, 11 June 2009 06:16

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

In addition, use dbms_random.

Regards
Michel

Report message to a moderator

Previous Topic:	Oracle 9i silent install on aix 5.3
Next Topic:	Using ps -ef \|grep LOCAL

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 08:40:46 CST 2024