oracle concat------sql语句连接字符串

    @Override
    public List<Map> getCasCadeKeySite(String indexCode) {
    	// TODO Auto-generated method stub
    	Object[] params = new Object[]{indexCode};
    	String sql = "SELECT ii.C_INDEX_CODE FROM IOT_PUSH_CONFIG ii,RESOURCE_KEYSITE rr ,"
    			+ "(SELECT I_ID FROM UOM_ORGANIZATION WHERE "
    			+ "C_PATH like concat (concat('%,',(SELECT u.I_ID FROM UOM_ORGANIZATION u "
    			+ "WHERE u.C_INDEX_CODE=?)),',%')  AND C_KEY_SITE_TYPE IS NOT NULL) ll "
    			+ "WHERE rr.C_INDEX_CODE=ii.C_INDEX_CODE "
    			+ "AND rr.I_FICTITIOUS_ORG_ID = ll.I_ID AND ii.I_KEYSITE_TYPE=0 AND ii.I_STATUS=0 ";
    	return queryForList(sql, new Object[]{indexCode});
    }

用了两次concat，用法如代码，比较简单