HELLO ALL,

URGENTLY NEEDED A SCRIPT TO SELECT AND DELETE LOWER AND MIXED CASE RECORDS FROM A COLUMN IN A TABLE.

FOR EXAMPLE : Table name is EMPLOYEE and the column name is CITY
and the CITY column records will be: Newyork
washington
dallas
New jersey
Texas.... and so on.... many records will be there in this CITY column,

Both the lower case and also the record which starts with UPPER CASE like 'NewYork '
should retrieve and delete from the one column in one particular table.

Thanks in anticipation!!!

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)

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