Data Definition Language (DDL) is used to describe an object in SQL. When you model a table in your relational model using Oracle SQL Developer Data Modeler, you are probably very curious as to the code that is being generated to represent that object.

You can peek into this code using your mouse –

The Code behind the pretty picture

You can right-mouse-click on an object and choose ‘DDL Preview,’ or you can use the keyboard shortcut, Alt+Shift+I.

Here’s trick #1:

Mouse Over an object to get the DDL

Once the previewer is open, it’s dynamic. So click on another object in the model, and it will auto-refresh.

Auto-Generate DDL Text By Clicking on the Objects

And trick #2:

Change How the DDL is generated on the fly

Open the Preferences dialog under the Tools menu and proceed to the DDL page. There you can specify how to generate the DDL including:

  • Use Quoted Identifiers — this drives me nuts!
  • Generate Inline Column Constraints
  • Generate Comments in RDBMS

After you make this change, simply click back into the object and the DDL will auto-refresh based on your new setting. Here’s an example of how that looks with Quoted Identifiers.

The Options

DLL Generation Options

Previewing the Code

My object names are now case-sensitive, enjoy suckers!

You can expect more options and flexibility when it comes to generating the DDL in upcoming versions of SQL Developer Data Modeler. If you want to see something in particular be sure to add the request formally, or leave me a comment here.

thatjeffsmith
Author

I'm a Master Product Manager at Oracle for Oracle SQL Developer. My mission is to help you and your company be more efficient with our database tools.

4 Comments

  1. Hi Jeff,
    Thanks for your website and all answers !
    I have an issue with SQL Developer Data Modeler. Since I have versionned (with Subversion) my diagram I can’t export it to DDL statement for Oracle Databases.
    I have post an question to Oracle Community (https://community.oracle.com/message/12629531) you will see a screenshot.
    Thank you very much for help.

  2. Chuck Martin Reply

    Jeff thanks for this informative website. Do you know of a way to limit the line length when generating table data insert statements? We are setting up a code and data deployment system and one problem is when “insert statements” are generated from existing table, sqldev sometimes generate lines with >2499 char length, and of course sqlplus errors in running those (SP2-0027). Thanks in advance for your tips!!

  3. Very cool! I did not know about the mouse over trick to see DDL on any object in the diagram. (Plus the animation on the figure in the post is really cool.

    • thatjeffsmith

      I didn’t know about it either until the developer showed us in a team meeting. I figured it was hard to explain in words or even screenshots, so I built the animated GIF using Camtasia.

Reply To Chuck Martin Cancel Reply