动态SQL

2019独角兽企业重金招聘Python工程师标准>>>

1. Native Dynamic SQL
2. DBMS_SQL Package

题外：外连接 NVL

select xs.xm,nvl(zc.zczt,'0') zczt
from xsxxgl_xsjbxx xs,（select xsid,zczt from xsxxgl_xszc where xn='2017' and xqm='1'）zc
where xs.xsid=zc.xsid(+) and xs.xsid='02101405020'

转载于:https://my.oschina.net/u/3646781/blog/1518714