Home
Feed

Extend

Hashnode Pro
Hashnode for Agents

Resources

The foreword
Hashnode gql skill

Buildful - AI coding agent that delivers frontier-level results at a fraction of the cost Bug0 - The AI-native e2e QA regression testing Hackathons Changelog Brand @hashnode on X Hashnode on LinkedIn Support - hello+support@hashnode.com Code of Conduct Terms Privacy Sitemap

Search Hashnode

Search posts, tags, users, and pages

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

Feed/

Discussion

sssuarez

Enterprise Apps For The Modern Era

Jul 29, 2022

Generate Data Fast with Oracle APEX Data Generator

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...

sandra-suarez.com12 min read

#orclapex #oracle #erp #data

Responses1

Markdown supported · ⌘↵ to post

Anton Nielsen

Bike shop mechanic

Aug 3, 2022

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.

sssuarez

Enterprise Apps For The Modern Era

Aug 3, 2022

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!

Anton Nielsen

Bike shop mechanic

Aug 3, 2022

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.