SQL约束大写字母(SQL constraint capital letter)

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