How to add custom SQL to your Data Models, TABLE INSERTs

Got this question from a Oracle SQL Developer Data Modeler user recently –

How can we add INSERT statements for our LOOKUP tables when generating DDL from our Data Model?

– very nice person from Portugal

Example, include the data for my LOCATIONS table

This is pretty straightforward:

1. Open the table in your relational model
2. In the Scripts section, add the needed code
3. In same area, specify WHERE to insert the code
4. Generate the DDL
5. In DDL options, enable/check the custom script
6. Click OK, and Enjoy

Here’s what that looks like –

Model and diagram with DDL, no INSERTs 🙁

Adding the script for my LOCATIONS table

Generate!

Enjoy

Since I opted to include the INSERTS at the end of the script, there they appear.

But wait, why does it look different than what I put in the table properties? It’s almost like, SQL Developer is formatting my SQL…or something.

Yes, that’s controlled here, in the Modeler preferences –