Can we call a stored function in the constraint of a table ?

Question

question

OraLearner asked Jan 11, '10

I would like to know whether we can call a stored function in a constraint of a table ? Thank you

oracle plsql function constraint

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2010-01-11T13:32:51Z

Andrew Mobbs answered Jan 11, '10

Yes. For example:

ALTER TABLE emp ADD CONSTRAINT caseCheckConstraint CHECK ( UPPER(ename)=ename )

Uses the UPPER function in a check constraint.

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 2 · 2011-01-07T15:49:21Z

temp answered Jan 7, '11

Unless it is an user-defined function.

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.