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 laterInformation in this document applies to any platform.
Goal
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.
Solution
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 |
Solution |