SQL constraint capital letter

Question

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)

[Falsehoods programmers believe about names](https://www.kalzumeus.com/2010/06/17/falsehoods-programmers-believe-about-names/) might be worth a read :-) — Damien_The_Unbeliever, Jul 19 '16 at 09:53
this could help: http://stackoverflow.com/questions/7621568/oracle-11g-check-constraint-with-regex — Thomas, Jul 19 '16 at 10:31

score 1 · Accepted Answer · answered Jul 19 '16 at 10:37

1

The answer i've worked out is to use the Initcap function

So

FNAME            VARCHAR2 (15) CONSTRAINT Name_ck CHECK (fname=initcap (fname))

answered Jul 19 '16 at 10:37

Maestro

but why? handle casing application side rather than database side otherwise you might cause yourself some major headaches later on – Takarii Jul 19 '16 at 12:50

1 Answers1