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.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
asked: Jan 11 '10 at 11:59 AM
Seen: 957 times
Last Updated: Jan 12 '10 at 12:36 PM
Need help with Oracle Function to calculate values
Which function is used to find the difference between two dates ?
How does we keep a history of PL/SQL code changes ?
How can I protect my PL/SQL source code?
Is there a limit on the size of a PL/SQL block?
Can we create our own exceptions in oracle?
Possibility to Change CHARACTERSET of a database ?
What are Anonymous Blocks in PL/SQL ?
What is a deterministic function?
Is there any way to export a dropped table?
Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.Ask SQL Server Central is a community service provided by Red Gate.