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:
Regards