Forum Stats

  • 3,781,257 Users
  • 2,254,496 Discussions
  • 7,879,625 Comments

Discussions

Function and trigger templates in DM 19

Ziut
Ziut Member Posts: 363 Bronze Badge

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

BEGINNULL; END;

And my question:

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

pastedImage_16.png

Regards

Tagged:

Comments