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.

Function and trigger templates in DM 19

ZiutDec 16 2019 — edited Jan 26 2020

Hi

In DM 19.2, there is a bad pattern for creating functions in a physical model:

CREATE OR REPLACE FUNCTION MY_FUNCTION AS

Begin

NULL;

END;

This cannot be compiled..

The pattern should look the same as in SQL Developer:

CREATE OR REPLACE FUNCTION MY_FUNCTION RETURN VARCHAR2 AS

BEGIN

RETURN NULL;

END MY_FUNCTION;

I believe that you can use the wizard to create function with SQL Developer to specify the function type.

Similarly, creating a trigger can be inserted as Trigger Body:

BEGIN

NULL;

END;

And my question:

Can you place the cardinality property on the logical diagram as below:

pastedImage_16.png

Regards

Comments

Processing

Post Details

Added on Dec 16 2019
1 comment
254 views