✍ Kashif M ™
☎ +91 9994883085
✉ kashif7222@gmail.com


Saturday, 7 September 2013

Check contrains in oracle

By on September 07, 2013

How to handle case senstive data in oracle by check contrains

I have a table which insert both upper and lower case data get inserted in my table

So, Now I need to insert only upper case in my table..

we have acheive it by the following query as mention below.

Alter Table Xxbkpi_Lookup
Add Constraint Xxbkpi_Lookup_Unq_Ck   
Check (Lookup_Type = Upper(Lookup_Type) And 
Lookup_Code= Upper(Lookup_Code))

mkashu: Check contrains in oracle
Review : Kashif | Kashif
Update: September 07, 2013 | Rating: 4.5

Comment for "Check contrains in oracle"


Post a Comment

Blog Archive