SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Case insensitive unique constraint

Rajan SwDec 19 2012 — edited Dec 19 2012

Hi Guys,

Is it possible to create an unique constraint which is case insensitive

I mean if there is a unique constraint on col name

then
Both 'James' and 'JAMES' should not be allowed

Regards,

Papi

This post has been answered by jeneesh on Dec 19 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 16 2013

Added on Dec 19 2012

4 comments

10,354 views