The only thing you need to know is the table name:
col the_string format a30
select * from abc;
WITH con_line AS
( SELECT ROWNUM rownbr, REGEXP_REPLACE( COLUMN_VALUE, '
*<[^>]*>[^>]*>', ';' ) the_string
FROM TABLE( XMLSEQUENCE( CURSOR( SELECT *
FROM abc ))))
SELECT a1.*
FROM con_line a1
WHERE EXISTS( SELECT 'x'
FROM con_line a2
WHERE a1.rownbr <> a2.rownbr AND(( a1.the_string =
a2.the_string )));
MYNUM MYDATE
---------- ---------
10 14-JUL-04
10 14-JUL-04
20 27-JUL-08
20 27-JUL-09
4 rows selected.
ROWNBR THE_STRING
---------- ------------------------------
2 ;10;14-JUL-04;
1 ;10;14-JUL-04;
2 rows selected.
On Sun, Mar 28, 2010 at 11:25 PM, Niraj Parihar <
[email protected]> wrote:
> Can any body help me on a query where i have to find out the number of
> duplicate records in a table independent of the columns defined in a table.
> --
> Thanks and Regards,
> Niraj Singh Parihar
>
> --
> You received this message because you are subscribed to the Google
> Groups "Oracle PL/SQL" group.
> To post to this group, send email to [email protected]
> To unsubscribe from this group, send email to
> [email protected]
> For more options, visit this group at
> http://groups.google.com/group/Oracle-PLSQL?hl=en
>
> To unsubscribe from this group, send email to oracle-plsql+
> unsubscribegooglegroups.com or reply to this email with the words "REMOVE
> ME" as the subject.
>
--
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
To unsubscribe from this group, send email to
oracle-plsql+unsubscribegooglegroups.com or reply to this email with the words
"REMOVE ME" as the subject.
