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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
359 views