Use the following script

ALTER TABLE <table_name> ADD (
CHECK (length(<column_name>) > 2))



-----Original Message-----
From: Andrews, Daryl [mailto:[Email Address Removed] Sunday, June 29, 2003 05:05
To: LazyDBA.com Discussion
Subject: Minimum input for a table field


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
Oracle LazyDBA home page