Just a check constraint would do...

-----Original Message-----
From: Martin Brown [mailto:[Email Address Removed] Sunday, June 29, 2003 08:52
To: LazyDBA.com Discussion
Subject: Re: Minimum input for a table field


I think I would try an insert or update trigger that uses the length
function on the column in question.


>From: "Andrews, Daryl" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Minimum input for a table field
>Date: Sun, 29 Jun 2003 08:04:41 -0400
>
>Hi all,
>
>I have a field of a table that is varchar2(20). I'd like for whatever is
>input into that field to be at least 3 characters in lenght. How can I set
>a minimum input parameter for a varchar field lenght?
>
>Thanks.
>
>--------
>Oracle documentation is here:
>http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
>To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
>Tell yer mates about http://www.farAwayJobs.com
>By using this list you agree to these
>terms:http://www.lazydba.com/legal.html
>

_________________________________________________________________
MSN 8 with e-mail virus protection service: 2 months FREE*
http://join.msn.com/?page=features/virus


--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page