Page 1 of 1

create tables and insert dummy data into tables based on given design

Posted: Tue 31 Dec 2019 02:05
by vasuv
Hi Experts,

I am Amy, working on Oracle 12.2 I am having DB design and now would like to create and insert dummy data into tables the data and tables should satisfy Parent and Child relationships too. Please advise, is it possible to create tables ( have created tables) and insert data ( dummy data) souldsatify mappings. Is it possble only manually or cando it using any tool.

Thanks
Amy

Re: create tables and insert dummy data into tables based on given design

Posted: Tue 31 Dec 2019 05:53
by alexa
Hello.

This can be performed with dbForge Data Generator for Oracle https://www.devart.com/dbforge/oracle/data-generator/download.html

Please see the following documentation http://docs.devart.com/data-generator-for-oracle/

The following demo videos for the similar our products would also of help:
https://www.youtube.com/watch?v=hhh-BC4ypdY
https://www.youtube.com/watch?v=MYdTfRPAG34
https://www.youtube.com/watch?v=8Lu4yYtuJ18

dbForge Data Generator for Oracle is also included as a feature in another our product dbForge Studio for Oracle https://www.devart.com/dbforge/oracle/studio/download.html

You can download the fully featured 30-day Trial versions of the products for evaluation.

Please let us know if specific questions arise.