'select a.CATV_CD,a.ARTCL_NAME,a.ARTCL_CD,to_char(a.APPLY_STRT_DT,''yyyy/mm/dd'') APPLY_STRT_DT, to_char(a.APPLY_END_DT,''yyyy/mm/dd'') APPLY_END_DT,b.CATV_NAME_ABRVT from CO_ARTCL_MAST a,CO_CATV_BASIC b where a.CATV_CD = Vcatvcd and a.ARTCL_NAME like ''%'||Vartclname||'%'' and to_char(a.APPLY_STRT_DT,''yyyymmdd'') >='||Vappstrdtfm||' and to_char(a.APPLY_STRT_DT,''yyyymmdd'') <='||Vappstrdtto||' and b.CATV_CD = a.CATV_CD';
like '%'||Vartclname||'%'
oracle认为'%Vartclname%'只是一个字符串
'%'||Vartclname||'%'即可
to_char(a.APPLY_END_DT,''yyyy/mm/dd'') APPLY_END_DT,b.CATV_NAME_ABRVT
from CO_ARTCL_MAST a,CO_CATV_BASIC b
where a.CATV_CD = Vcatvcd and a.ARTCL_NAME like ''%'||Vartclname||'%''
and to_char(a.APPLY_STRT_DT,''yyyymmdd'') >='||Vappstrdtfm||'
and to_char(a.APPLY_STRT_DT,''yyyymmdd'') <='||Vappstrdtto||'
and b.CATV_CD = a.CATV_CD';