I would like to know whether we can call a stored function in a constraint of a table ? Thank you
Jan 11, 2010 at 11:59 AM
Jan 12, 2010 at 12:36 PM
Yes. For example:
ALTER TABLE emp ADD CONSTRAINT caseCheckConstraint CHECK ( UPPER(ename)=ename )
Uses the UPPER function in a check constraint.
Jan 11, 2010 at 01:32 PM
Unless it is an user-defined function.
Jan 07, 2011 at 03:49 PM
Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
Need long-form SQL discussion? SQLserverCentral.com is the place.
asked: Jan 11, 2010 at 11:59 AM
Seen: 2160 times
Last Updated: Jan 12, 2010 at 12:36 PM
Need help with Oracle Function to calculate values
What are cascading triggers? What is the maximum no of cascading triggers at a time?
How does one load multi-line records?
Can Check constraint be used for self referential integrity ? How ?
What are the various types of parameter modes in a procedure ?
Oracle DDL in autonomous transaction
Difference between case and code statements in oracle?
Receiving Error Messages in Oracle
Can 2 functions have the same name & input parameters but differ only by return datatype ?