✍ Kashif M
Trends

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



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

Comment for "Check contrains in oracle"

0 comments

Post a Comment

Blog Archive