SELECT m1.mkt_id m1,
       m2.mkt_id m2, 
       sdo_relate(m1.shape, m2.shape, 'mask=contains+inside+covers+overlapbdyintersect+equal+on+coveredby') rela
  FROM cola_markets m1 
 INNER JOIN cola_markets m2 
    ON (m1.mkt_id<>m2.mkt_id)
 WHERE sdo_relate(m1.shape, m2.shape, 'mask=contains+inside+covers+overlapbdyintersect+equal+on+coveredby+touch')='TRUE';

m1      m2      rela
--------------------------- 
2	1	FALSE
3	1	TRUE
1	2	FALSE
3	2	TRUE
2	3	TRUE
1	3	TRUE