把下面这段sql变成Oracle写法!!!急!

下面这段sql放到Oracle里该怎么写呢?现在直接放过去,报错索引中丢失 IN 或 OUT 参数:: 3

SELECT ebi.* FROM eplus_building_info ebi
INNER JOIN eplus_relationship er ON ebi.id::text = er.target_key AND er.relationship_type = 'institution_building'
WHERE er.source_key IN (
WITH RECURSIVE r AS (
SELECT * FROM eplus_institution WHERE id::text = #{instId}
UNION ALL
SELECT ei.* FROM eplus_institution ei, r WHERE ei.parent_id = r.id
)
SELECT DISTINCT(id::text) FROM r
)

AND ebi.building_name like CONCAT('%',#{buildingName},'%')

查看全部
hhhCSDNbk
Hui_F
2017/08/31 05:50
  • oracle
  • sql
  • 点赞
  • 收藏
  • 回答
    私信

3个回复