How to Delete the Duplicate Records in oracle SQL

Опубликовано: 07 Апрель 2016
на канале: Ram Gupta

30,708

246

http://oracletemple.blogspot.in/

How to Delete the duplicate records

Tips: - Always take extra caution while deleting records.
1. First identify the duplicates using select.
2. Double verify those are actual ‘duplicates’ or not
3. Take backup if necessary
4. Apply commit only if you are sure.

~-~~-~~~-~~-~
Please watch: "difference between delete and truncate"
   • Difference Between Delete and Truncate
~-~~-~~~-~~-~

------------------------------------------------------------------
Below is link for Useful Pl/SQL Books
http://goo.gl/XMy0tt
----------------------------------------------------------
---------------------------------------------------------------

Watch More...

What is Parameterized Cursor in Oracle
   • What is Parameterized Cursor in Oracle

What is autonomous transaction in Oracle.
   • What is Autonomous transaction in Oracle

What are Constraints available in Oracle.
   • What are Constraints in Oracle - [ SQ...

What is Mutation Error and How to avoid mutation.
   • What is Mutation in oracle

5 Effective way to delete Duplicate rows
   • How to Delete the Duplicate Records i...

What is Difference between Delete and Truncate
   • Difference Between Delete and Truncate