Re: Limit characters in a field

Krishna Vellakkat 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

Use a BEFORE-INSERT OR UPDATE trigger on the table.

Removed your cross-post to c.d.o.tools.

Daniel Morgan Received on Fri Feb 14 2003 - 10:37:55 CST