---
title: "Discussion on \"Generate Data Fast with Oracle APEX Data Generator\" | Hashnode"
description: "Discussion on \"Generate Data Fast with Oracle APEX Data Generator\". A Must For Developers, Testers & Analysts In Your Organization"
url: "https://hashnode.com/posts/apex-data-generator/62e428c5430bd1d04a83f317"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Generate Data Fast with Oracle APEX Data Generator](https://sandra-suarez.com/apex-data-generator?utm_source=hashnode&utm_medium=feed)

A Must For Developers, Testers & Analysts In Your Organization

Jul 29, 2022 · 12 min read · sandra-suarez.com  
Updated Aug 3, 2022  
Read the article

-   [#orclapex](https://hashnode.com/tag/orclapex)
-   [#oracle](https://hashnode.com/tag/oracle)
-   [#erp](https://hashnode.com/tag/erp)
-   [#data](https://hashnode.com/tag/data)

## Written by

[sssuarez](https://hashnode.com/@sssuarez)

@sssuarez · San Diego, CA

  
[View profile](https://hashnode.com/@sssuarez)

Enterprise Apps For The Modern Era

I build, enhance, and automate enterprise workflows for a living. Oracle ERP (Fusion Cloud and EBS) is my home base. My favorite tool for extending the enterprise is Oracle APEX - there's almost nothing it can't do.

## Responses 1

Markdown supported · ⌘↵ to post

[Anton Nielsen](https://hashnode.com/@ainielsen)

[Aug 3, 2022](https://hashnode.com/posts/apex-data-generator/62e428c5430bd1d04a83f317/comment/62ea7eca16f9480a9dac5eaf)

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](https://hashnode.com/@sssuarez)

[Aug 3, 2022](https://hashnode.com/posts/apex-data-generator/62e428c5430bd1d04a83f317/comment/62ea7eca16f9480a9dac5eaf#reply-62eaca7692b7fd0a78c37594)

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](https://hashnode.com/@ainielsen)

[Aug 3, 2022](https://hashnode.com/posts/apex-data-generator/62e428c5430bd1d04a83f317/comment/62ea7eca16f9480a9dac5eaf#reply-62ead3cf92b7fd0a78c376af)

[sssuarez](https://hashnode.com/@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.
