Identical names List

[hrishy]

Hi Agsimani

please have a look below...

SQL> select * from agsimani
2 /

ROW_NUM COL1
---------- -------------------------
1 abc and co 9 5
2 xyz est 3 2
3 queen hotel 2 9
4 abc & co 9 5
5 king company 4 ,2
6 xyz establishment 3 2

6 rows selected.

SQL> select t1.row_num,t1.col1,t2.col1,t2.row_num
2 from agsimani t1, agsimani t2
3 where
4 substr(t1.col1,1,3) like substr(t2.col1,1,3)
5 and
6 t1.row_num<>t2.row_num
7 /


ROW_NUM COL1 COL1 ROW_NUM
-- ---------------------- ---------------------- -------
4 abc & co 9 5 abc and co 9 5 1
6 xyz establishment 3 2 xyz est 3 2 2
1 abc and co 9 5 abc & co 9 5 4
2 xyz est 3 2 xyz establishment 3 2 6