Oracle SQL Developer Data Modeler 4.0

New Features

December 2013

This document is a list of the main new features in SQL Developer Data Modeler 4.0.

DDL Generation

Support for Code folding in DDL file editor
"Generate Valid Value Constraints" option to generate DDL without List of Values and Range of Values constraints
Option to split generated DDL in separate files
Option to include SQL*Plus Prompt command in generated DDL


Option to show/hide classification types on diagrams in logical and relational models
Logical model:
 - "Resize to visible" works on hierarchical entities
 - Auto layout functionality for diagrams in logical model
Display "Comments in RDBMS" for Tables, Columns, Entities and Attributes on the diagram
"Show page grid" option is added

Engineering between Logical and Relational

Added support for table_template during engineering to relational model
Subview can be used as selector of objects to be engineered from relational to logical model


Design level preferences are moved to design dialog
Additional classification types can be set on entities and tables
Option to show external log file - View>External Log

Logical Model

Sorting of attributes in entities – can be applied on Logical model, a group of selected entities and in entity dialog
Entities and attributes can be set as deprecated


Mask templates can be defined and used in definition of columns with sensitive information.
Support for REDACTION policy definition on table and column level.
Support for Transparent Sensitive Data Protection (TSDP) policies:
- Sensitive types can be created and associated with domains, columns and attributes TSDP policies can be created and associated with sensitive types

Physical Model Oracle

Support sub-partitioning for Hash partitions (Oracle 11g)
Added “Propagate Properties” functionality for users and roles
“Propagate Properties” functionality for table now also covers partitions
Propagate Properties option for Views, Procedures, Functions, Packages, Primary and Unique Keys

Physical Model Oracle 12c Database

Support for IDENTITY Columns - with option to be implemented using sequence and trigger or new syntax for identity column
Option to generate DDL for an auto-increment column using a DEFAULT clause referring to the NEXTVAL of a Sequence
DEFAULT ON NULL clause for columns for explicit NULL insertion
Increased size limit for VARCHAR2, NVARCHAR2 and RAW data types
Session sequences
Invisible columns
Import of Redaction and TSDP policy definitions form database
Redaction and TSDP policy definitions can be included in generated DDL


"Print to PDF file" is added in "Print to Printer" functionality

Query Builder

Added option to disable/enable auto join on FKs/Relationships in Query Builder

Relational Model

View columns – added support for notes and comments
Tables and Columns can be set as deprecated
“Clear Source Stamp” can be applied on a group of selected objects – removes source information (database or DDL file) logged for selected objects
"Split relational model by schema name" wizard – to split large models into smaller models and transforming source model in read-only mode
Table - added support of Valid Time dimensions introduced in Oracle 12c Database - can be added, imported from Oracle 12c Database and generated in DDL


Added SQL script for granting read only access to reporting repository
Standard reports – already created diagrams can be reused in next reports
Custom reports:
- Reports with two levels of details can be created for Entity, Table (relational model), Table (physical model Oracle), Structured type, Cube and  Dimension (in multidimensional model)
- Custom reports are available in functionality for standard reports (File>Reports)


Advanced mode:
 - Negation clause can be added to search expression
 - Search for empty value is supported


SVN 1.7 client is included