SQL约束大写字母(SQL constraint capital letter)
如何创建一个约束,期望字符串以大写字母开头,后跟小写字母,例如Peter
我知道怎么做全大写
NAME VARCHAR2 (12) CONSTRAINT NAME_chk CHECK name = UPPER (name)How do I create a constraint that expects the string to start with a capital letter followed by lower case letters, e.g Peter
I know how to do full uppercase
NAME VARCHAR2 (12) CONSTRAINT NAME_chk CHECK name = UPPER (name)最满意答案
我得出的答案是使用Initcap功能
所以
FNAME VARCHAR2 (15) CONSTRAINT Name_ck CHECK (fname=initcap (fname))The answer i've worked out is to use the Initcap function
So
FNAME VARCHAR2 (15) CONSTRAINT Name_ck CHECK (fname=initcap (fname))更多推荐
发布评论