Re: Limit characters in a field

From: Frank <fvanbortel_at_netscape.net>
Date: Fri, 14 Feb 2003 21:20:18 +0100
Message-ID: <3E4D4F82.9030003@netscape.net>

DA Morgan wrote:
> 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
>

Cross-post removal a bit too rigorous, to my liking. I was going to refer him to front-end tools (as Forms, Java, HTML + Javascript) as well, and that would be an answer for c.d.o.tools.

Sorry to put a tools answer in the misc ng ;-)

HANW!

-- 
Regards, Frank van Bortel

Received on Fri Feb 14 2003 - 14:20:18 CST