Home » Other » General » Re: Deleting Duplicate Records
Re: Deleting Duplicate Records [message #101980] Sat, 22 December 2001 19:41
ashutosh
Messages: 6
Registered: December 2001
Junior Member
1. get all the distinct records in temporary table
2. truncate orignal table
3. copy data back into orignal table .
NOTE : Always Truncate the orignal table and do not use DELETE statement for this purpose b'se DELETE fires TRIGERRS (if attached ) and truncate dosent.

----------------------------------------------------------------------
Previous Topic: i only know oracle and developer
Next Topic: Re: dumps on CCNA,
Goto Forum:
  


Current Time: Thu Mar 28 23:58:38 CDT 2024