Hi Abhilash,

you should use the following query in ur script to delete the records other than upper case

select * from employee where city not in ucase(city)
delete from employee where city not in ucase(city)

***************script wiill be like this************

$SQLPLUS username/password@schemaname @query.sh>temp.log

where query.sh contains the following query

delete from employee where city not in ucase(city)

***********************************************