Home » SQL & PL/SQL » SQL & PL/SQL » how to find duplicate record ?
how to find duplicate record ? [message #206202] Wed, 29 November 2006 03:22 Go to next message
methekar_onkar
Messages: 1
Registered: November 2006
Location: THANE
Junior Member
how to find a duplicate record in table by pl/sql block?
Re: how to find duplicate record ? [message #206216 is a reply to message #206202] Wed, 29 November 2006 03:52 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
I read it wrong....

How to find in the sense??
Do you want to display duplicate records?

By
Vamsi

[Updated on: Wed, 29 November 2006 03:54]

Report message to a moderator

Re: how to find duplicate record ? [message #206220 is a reply to message #206216] Wed, 29 November 2006 03:57 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Why would you need a PL/SQL to do that? There's an article on OraFAQ about deleting duplicates. Adjust these queries so that they will only select, and not delete records.
Previous Topic: Error while selecting the data
Next Topic: Tricky query
Goto Forum:
  


Current Time: Sat Dec 10 01:04:10 CST 2016

Total time taken to generate the page: 0.08143 seconds