Skip to Main Content

data case sensitive Validation

User_7PZDEMay 31 2017 — edited Jun 1 2017

Hi Team

I have scenario to check the data case sensitive i.e

I have table called parther_grouping

create table parther_groupingĀ  ( Parther_Main_Group Varchar2(100));

insert into parther_grouping values ('Data Main');

insert into parther_grouping values ('Data Main');

insert into parther_grouping values ('Oracle');

insert into parther_grouping values ('data Main');

select Parther_Main_GroupĀ  from parther_grouping ;

Data Main

Data Main

Oracle

data Main

If see above column Parther_Main_Group i have group of Data Main with 3 and One is small letter *d*(data Main)

i need to find those records it is just example script i have around 10,000 recrods Parther_Main_Group

Version Oracle 9i

Thanks in Advance

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked due to inactivity on Jun 29 2017
Added on May 31 2017
7 comments
262 views