Discussion on "Generate Data Fast with Oracle APEX Data Generator"

sssuarez · 2022-07-29T19:14:05.000Z

Introduction A high-quality application relies on thorough testing. Generating sample data fast is vital for keeping up with today's world of Agile and condensed timelines. Traditional methods for generating data have too many downfalls: manual ma...

Great blog post, Sandra! I have a little hack for you. If you want to re-sequence a column, just right click on the "read only" sequence number and remove readonly="true". Supported? Definitely not, but it works just fine :)

Also, you should be able to generate directly into tables even if you create a blueprint from scratch. You just need to make sure the table names, columns, constraints, etc. all work.

Thanks Anton for visiting and reading my blog and for your comments too. I appreciate the hack and I retested the feature to generate directly into tables and yes, as long as the table name on your blueprint is an exact match to the table name in your schema, it works. I've updated the blog with this tip. Thanks again!

sssuarez Just one more tip...OADG is accessible via APIs (note: I wasn't able to post links, so I put a space between https:// and the rest of the URL): https:// docs.oracle.com/en/database/oracle/apex/22.1/aeapi/APEX_DG_DATA_GEN.html In particular, if you want to generate data into just one table, you can use APEX_DG_DATA_GEN.GENERATE_DATA https:// docs.oracle.com/en/database/oracle/apex/22.1/aeapi/GENERATE_DATA-Procedure-Signature-1.html

Use p_blueprint_table to specify the table name.

Discussion

Generate Data Fast with Oracle APEX Data Generator

Responses(1)

Recent in Forum

Search Hashnode

Generate Data Fast with Oracle APEX Data Generator

Responses(1)

Recent in Forum