The select zz from aa where (vv like '%' | | : ls_vv | | '%' or (cc like '%' | | : ls_cc | | '%')) and zt='T' and ZTW=: ls_ss;
After the where statement how to explain, | | what is representative, () what meaning be

CodePudding user response:

Waiting for the

CodePudding user response:

Use of oracle,
| | can be used in the connection string
() is used to limit the scope of the

(vv like '%' | | : ls_vv | | '%' or (cc like '%' | | : ls_cc | | '%')) and zt='T' and ZTW=: ls_ss

Can be understood as three conditions and
(vv like '%' | | : ls_vv | | '%' or (cc like '%' | | : ls_cc | | '%'))
Zt='T'
ZTW=: ls_ss

If there is no outside ()
To understand as
V. v. like '%' | | : ls_vv | | '%' or on
(cc like '%' | | : ls_cc | | '%') and zt='T' and ZTW=: ls_ss

(cc like '%' | | : ls_cc | | '%') of () can not

CodePudding user response:

Pick up points is king!