-
add a CAPS constraint
Hi Friends,
How do I put contraints on my NAME column on EMP table so that all
the data saved are all CAPS?
Is this the correct syntax?
allter table EMP modify(NAME check upper(NAME));
or
allter table EMP modify(NAME default upper(trim(NAME)));
Thanks
Last edited by jennifer2007; 02-19-2007 at 11:40 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|