SELECT c.yhid as id, c.hm as value, ZD.ZT AS ZT, C.HH AS HH, C.DWDM AS DWDM FROM yh_yh c, ZC_ZDZC ZD where c.hm LIKE '%╭∩╮（︶︿︶）╭∩╮%' and c.dwdm in (SELECT DISTINCT T.DWDM FROM XT_DWDM T START WITH T.DWDM = '330000' CONNECT BY PRIOR T.DWDM = T.SJDWDM AND T.DWDM != T.SJDWDM )
AND C.YHID = ZD.YHID(+) AND ROWNUM < 800
上面是正确的SQL

在控制台里根本就没有╭∩╮（︶︿︶）╭∩╮