I would like to know whether we can call a stored function in a constraint of a table ? Thank you
Jan 11 '10 at 11:59 AM
Jan 12 '10 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 '10 at 01:32 PM
Unless it is an user-defined function.
Jan 07 '11 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.
There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.
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 '10 at 11:59 AM
Seen: 1274 times
Last Updated: Jan 12 '10 at 12:36 PM
Need help with Oracle Function to calculate values
Is there a limit on the size of a PL/SQL block?
How do I code an anonymous PLSQL block?
Can we create our own exceptions in oracle?
Possibility to Change CHARACTERSET of a database ?
What is a deterministic function?
Is there any way to export a dropped table?
Can one use dynamic SQL within PL/SQL?
Date Calculations - First of Month, Last of Month, More
What are the return values of functions SQLCODE and SQLERRM ?