Re: Limit characters in a field

From: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: 15 Feb 2003 08:16:50 GMT
Message-ID: <b2kt1i$1dmeqh$1@ID-82536.news.dfncis.de>

> 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.

A 'trigger' solution undoubtly does not belong to c.d.o.tools. Yours might, but then, nobody stopped you from doing so.

Rene Nyffenegger

-- 
  no sig today

Received on Sat Feb 15 2003 - 02:16:50 CST