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

Last updated on JUNE 24, 2021

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

Goal

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