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

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
vasuv
Posts: 1
Joined: Tue 31 Dec 2019 01:53

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

Post by vasuv » Tue 31 Dec 2019 02:05

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

alexa
Devart Team
Posts: 2885
Joined: Fri 24 Jun 2011 14:17

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

Post by alexa » Tue 31 Dec 2019 05:53

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.

Post Reply