Hi @rajeshjanapati and @shivakumara Thanks for your replyDELETE FROM EmpDataWHERE ROWID NOT IN (SELECT MAX(ROWID)FROM EmpDataGROUP BY EMPID, EMPNAME,DESIGNATION, LOCATION)by using this above query the duplicated records are deleted from oracle datab...
Hi Bhagya,Thanks for your reply.I used sql collections also there with distinct query get the unique records but want to delete all the duplicate records from the data table tried with other sql queries which are not working.
