Default Value Setting
The rule to set the database default value is the following:
• When a predefined default value is not available, set the default value of Non-null CHAR or VARCHAR columns to blank except the primary key columns.
• When a predefined default value is not available, set the default value Non-null Number columns to 0 (zero) except the primary key columns.
• No database default values should be assigned to the Non Null Date, Time, and Timestamp columns.
Parent topic