> We Normally provide PRIMARY KEY in every Table.
> But Sometimes we forget or for some reason we do not provide primary
> key in table.
> In that case it is very difficult to delete one of the two duplicate
> records
>
> Just an Example:
> ======================================
> DEPT_ID DEPT_NAME
> 10 CHEMICAL
> 10 CHEMICAL
> 10 CHEMICAL
> ======================================
>
> Here I Entered Three duplicate records my mistake and I want to keep
> only One Unique Record, So if would have been Any Feature to Uniquely
> Identify the Row I would be able to Delete that row using that UNIQUE
> ID as Oracle Supports.

For this specific case, read these:
http://www.cvalde.net/document/mysteriousDbKey.htm
http://www.cvalde.net/document/practical_use_of_the_rdb.htm

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com