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
Popular Posts
-
Unleashing the Power of AI Within Your Oracle Database: Introducing oracle_ai_plsql_agent The world of Artificial Intelligence (AI) is rapi...
-
FS_CLONE Phase It is a stand-alone command used for file system cloning. Standard cloning (using adcfgclone.pl) cannot be used to synch...
-
If you are an EBS administrator the first thing some asks you to do a health check of an environment , you return to him with a Request ID o...
-
[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...
-
SAP BO and DS with Oracle Database Part 5 Verifying CMC and DS Now that we are done with the installation , we have to verify CMC and DS ...
-
Oracle EBS 12.2 - ADOP ad_zd_prep.create_patch_service exceptions Please note , if you get ADOP issues on PROD please read the logs and ...
-
Using Discoverer Admin Edition: 1. Connect to the Discoverer Administrator Server 2. Add the TNS Entry to D:\ODisc10g\network\admin\tnsnames...
-
EBS 12.1 and 12.2 Product running 11.2.0.4 Database it is time to move forward to 19c Database Release. 19c CDB/PDB with EBS is a learning c...
-
CAUTION : This method is only for the TESTING Purpose. DO NOT BUILD PRODUCTION SYSTEM USING THIS PROCEDURE. Hardware Requirement : One Node ...