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: 2108
Registered: October 2003
Location: Hyderabad, India
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: 21127
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 Jul 22 20:12:53 CDT 2017

Total time taken to generate the page: 0.04765 seconds