Re: Limit characters in a field

On Fri, 14 Feb 2003 10:23:09 -0600, Krishna Vellakkat <vkrishna_at_siu.edu> wrote:

>Hi all,
>Is there some way to limit WHAT characters can be entered in to a field
>in an Oracle table?
>For eg., allow a field to have ONLY vowels (i.e., the characters
>a,e,i,o,u) and some punctuation marks (like single quotes, comma, double
>quotes, hyphen and a semicolon)?
>Thanks in advance,
>Krishna

Just use a check constraint with an IN clause that's all

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Feb 14 2003 - 21:21:38 CET