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!

DDL view generation fails

user-iiqfwJun 22 2023

I'm trying to generate DDL for a model with Data Modeler 23.1 and it fails but it works fine with Data Modeler 19.2.

The issue is on views definition when a view is composed by union of two tables and a column in the second table is defined by a function.

See picture in attachement.

In this example column “a_date” is duplicated. In DataModeler 19.2 the behaviour is as expected and just one column is generated.

Comments
Post Details
Added on Jun 22 2023
0 comments
421 views