My Oracle Support Banner

Table Column based on Domain does not inherit the size from the Domain when generating DDL (Doc ID 1537404.1)

Last updated on FEBRUARY 01, 2020

Applies to:

Oracle SQL Developer Data Modeler - Version All and later
Information in this document applies to any platform.


The DDL for column based on domain does not show the size of the column.

For Example:

Domain with datatype NUMBER and size 2, and values (1,2,3,4). A column called <column_name> is associated to this domain.

The generated DDL for the column is:

<column_name> NUMBER NOT NULL CHECK ( <column_name> IN (1, 2, 3, 4))

Here the size is missing in the DDL.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.