I would like to know whether we can call a stored function in a constraint of a table ? Thank you
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
Yes. For example:
ALTER TABLE emp ADD CONSTRAINT caseCheckConstraint CHECK ( UPPER(ename)=ename )
Uses the UPPER function in a check constraint.
Unless it is an user-defined function.
No one has followed this question yet.
Need help with Oracle Function to calculate values
Do we need a commit after DDL statements ?
What are the uses of Data Dictionary ?
Receiving errors firing triggers in Oracle
What is Over Loading and what are its restrictions ?