I was recently working on a project where there was a demand to have random set of sales and transaction data to test performance. Well I thought of a better solution and it worked out with this website http://www.generatedata.com
Interestingly the dataset can be generated directly on the website itself and the maximum rows that will be generated is 5000.
The result output can be on different forms like excel,csv,html,xml and sql.
SQL was the best part , the page gives option to select the database type and then the tablename.
By default it creates the script with the create tablename and then the insert statements.
I hope this will help people who need sample dataset.
The voice in my head may not be real , but they have some good ideas !!!
Fail Fast, Fail Forward, Fail Often, Fail Better , Standup Every Time
Every problem has at least one solution. Only some solutions are harder to find.
Monday, February 8, 2010
Subscribe to:
Posts (Atom)
Popular Posts
-
Unleashing the Power of AI Within Your Oracle Database: Introducing oracle_ai_plsql_agent The world of Artificial Intelligence (AI) is rapi...
-
[oracle@testebsop3app01 ~]$ perl /u01/install/APPS/fs1/EBSapps/comn/clone/bin/adcfgclone.pl appltop /u01/install/APPS/fs1/inst/apps/SATURN_...
-
PRVG-2031 : Owner of file "/u01/app/oracle/diag/crs/rac01/crs/lck" did not match the expected value on node "HOST1". [Ex...
-
FS_CLONE Phase It is a stand-alone command used for file system cloning. Standard cloning (using adcfgclone.pl) cannot be used to synch...
-
Here is a general outline of the automation process to send an email of the latest ADDM recommendation on an hourly basis. Here's how y...
-
With one of the main feature in 12.2 dual file system, there was always a need about having a single file system in 12.2 like 12.1.x and ge...
-
Abort Phase If for some reason either the prepare or apply phase failed or gave problems, you can abort the patching cycle. After runnin...
-
Ready the instance for cutover Perform the final operations like Compile Invalids , Generate Derived Objects and Pre-compute DDL to be run...
-
On EBS 12.2 the below script will help to find the EBS Application Module Name which are creating incident. There could be many reasons w...
-
You cannot change the circumstances, the seasons, or the wind, but you can change yourself. That is something you have charge of. Moving to ...