SQL> SELECT markfor
FROM
(SELECT
nvl(fdst.short_text,' ') markfor,
wlr.LABEL_REQUEST_ID
FROM
WMS_LABEL_REQUESTS wlr,
wsh_deliverables_v wdv,
<...snipped...>
AND ROWNUM=1 ;
ORDER BY fad.last_update_date(+) desc
*
ERROR at line 32:
ORA-30563: outer join operator (+) is not allowed here
或
SQL> select * from
2 (
3 select distinct
<...snipped...>
151 where seq=cnt start with seq=1 connect by prior seq+1=seq
152 and prior user_key=user_key(+) ) M
153 where user_details.USER_KEY = M.USER_KEY(+)
154 AND USER_DETAILS.USER_LEVEL_TYPE_CD not in (2,4)
155 )
156 order by 3 ;
and prior user_key=user_key(+) ) M
*
ERROR at line 152:
ORA-30563: outer join operator (+) is not allowed here