select max(test_result_sn) from tn_test_rcept_iem where test_result_sn in (select test_result_sn from tn_test_result) group by rcept_sn having count(rcept_sn) > 1 SELECT EXTRACTVALUE(COLUMN_VALUE, 'testitem/testprsecitem/text()') as aaa FROM TABLE(SELECT XMLSEQUENCE(XMLTYPE(C.CERT_CN).EXTRACT('/cert/testitems/testitemlist/testitem')) FROM TN_TEST_CERT C WHERE TEST_RESULT_SN = 1851)