Data creation for testing
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.