Hello everyoneI have scenario that 30k rows are there in a file want to retrive only the indentifier which belongs to 72411 from the file.any suggetion on these...?
Hi SatwikIts ascii content file as its not csv or any other the data should like thisC 01B 11 72411 28331571 EUR00100000052024051420250513 BURLET Jean-Crhistophe 107046000019 3 0000000160900000000000000000000000000000000000043600000000002740000000001...
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.
