sql的格式问题

select gid 
from t_grp_org 
where nodepath like '%(select gid from t_grp_org where gname = '北京')%'
错误提示ORA-00907：缺少右括号

问题sql如上，
我的解析如下
(select gid from t_grp_org where gname = '北京')结果正常为657232

select gid 
from t_grp_org 
where nodepath like '%657232%')则结果正常

所以我分析是sql执行顺序导致，希望能够调节格式实现

SQL code

select gid  
from t_grp_org  
where nodepath like '%'|| (select gid from t_grp_org where gname = '北京' and rownum=1) ||'%'

 

select gid  
from t_grp_org  
where nodepath like '%'+(select gid from t_grp_org where gname = '北京')+'%'

刚试了下，这样没问题