The FROM pd_dsp_notice PDN
LEFT the JOIN pd_dsp_notice_prompt PDNP ON PDNP. Notice_id=PDN. Id AND PDNP. User_id=3
LEFT the JOIN au_dealer au ON au.org anization_no=3
WHERE 1=1
AND (PDN) modify_date & gt;=sysdate - 180 OR PDN. State=1)
AND (PDN) promulgate_user_id=3 OR PDN) audit_user_id=3 OR
(PDN. Auditrs=1 AND
(PDN. Id IN (SELECT notice_id
The FROM pd_dsp_notice_viewer nv
WHERE nv. Viewuser_id=3) OR
((SELECT count (*) AS num
The FROM (
The SELECT regexp_substr (3, '[^ _] +, 1, level) AS s1
The FROM dual
CONNECT BY level & lt;=regexp_count (3, '_') + 1) d1
The JOIN (SELECT regexp_substr (PDN) brands, '[^ _] +', 1, 1) AS s2
The FROM dual
CONNECT BY level & lt;=regexp_count (PDN) brands, '_') + 1) d2 ON d2. S2=
D1. S1) & gt; 0 AND
(SELECT count (*) AS num
The FROM (SELECT regexp_substr (au) parent_area_code,
'[^ _] +'
1,
AS s1 level)
The FROM dual
CONNECT BY level & lt;=
Regexp_count (au) parent_area_code, '_') + 1) d1
The JOIN (SELECT regexp_substr (pdn.org s, '[^ _] +' 1, level) AS s2
The FROM dual
CONNECT BY level & lt; S=regexp_count (pdn.org, '_') + 1) d2 ON d2. S2=
D1. S1) & gt; 0 AND
(PDN. Busis IS NULL OR instr (PDN) busis, '2') & gt; 0)
))))
AND PDN. Promulgate_user_id=3
-- -- -- -- -- -- -- -- -- regexp_count (PDN) brands, '_')
The PDN. Brands identifier is invalid
CodePudding user response:
Separate out and execute try?CodePudding user response:
You bring regexp_count (PDN) brands, '_') in the PDN. Brands, with a constant try, such as for regexp_count (' abc_123 ', '_'),Because reference PDN. Here, outside the parentheses layers, doubt is cited here under the table,
CodePudding user response:
Oracle to multiple queries (using parentheses), only two floors, you this reference, at least three layer, want to bring up to,