hi members, Actually i want to delete duplicate records from my database. as far as i know oracle is provide unique ROWID so with help of ROWID we can delete duplicate only and left original one instead of all record relented to query..Answer are appreciated..