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
Receiving errors firing triggers in Oracle
Can we skip certain columns while loading data ?
What are cascading triggers? What is the maximum no of cascading triggers at a time?
Can we create our own exceptions in oracle?