Skip to Main Content

SQL Developer Data Modeler

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Add BY DEFAULT ON NULL option on identity column

PericlesFeb 16 2022

Hello
Building a table I've noticed that in SQL DEVELOPER (Data Modeler module) although you can define a column as IDENTITY and assign the options ALWAYS and BY DEFAULT, the option BY DEFAULT ON NULL is not being shown in the LOV.
image.pngThis only happens in Data Modeler module. In the table modification screen of SQL Developer are shown all the three options
image.pngI just downloaded the release 21.4.2 but this option is still missing, forcing to edit manually the DDL before merging the model with the database
It would be nice to have this option!.
Regards.

Comments
Post Details
Added on Feb 16 2022
1 comment
520 views