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!

Incorrectly generate DDL for column default value

_Dima_Jun 4 2020 — edited Jun 6 2020

Hello, it seems that Data Modeler does incorrectly generate DDL for column default value.

I use SYSDATE as default value for column CREATED_AT. Data Modeler generates DDL with SYSDATE in lowercase. Thus I end up forever not synchronized model with actual schema, as in my model used SYSDATE and in schema 'sysdate'.

Use Data Modeler 19.4, Oracle Base 12C, Oracle Linux 7.7

Please see screenshots

Screenshot from 2020-06-04 20-17-56.png

Screenshot from 2020-06-04 20-18-22.png

Screenshot from 2020-06-04 20-18-35.png

Screenshot from 2020-06-04 20-18-51.png

Did I make something wrong?

This post has been answered by Dave Schleis on Jun 5 2020
Jump to Answer
Comments
Post Details
Added on Jun 4 2020
1 comment
710 views