oracle字符串拼接
EXECsqlDECLAREcur_delaytransferCURSORFOR
SELECTvc_fundserialno,c_trust,vc_netno,vc_tradeacco,
abs(nvl(en_occurbala,0)),vc_identitynoinbank,c_identitytypeinbank,c_bankno,
vc_bankname,vc_bankacco,vc_nameinbank,c_moneytype,
vc_occurdate,vc_cdcard,c_capitalmode
FROMtfundcurrent_net
WHEREc_type='851'
ANDc_businflag='804'
ANDc_busincause='235'
ANDc_state='2'
ANDnvl(c_delayflag,'0')=1
ANDnotexists(select1fromtnorealtransfertime
wherec_capitalmode=tfundcurrent_net.c_capitalmode
and:sMachineDate||:sMachineTime>=nvl(vc_begindate,:sMachineDate)||nvl(vc_begintime,'000000')
and:sMachineDate||:sMachineTime<=nvl(vc_enddate,:sMachineDate)||nvl(vc_endtime,'240000')
andrownum<2);
如果字符串都是数字的话，则可以直接比较大小写。
原文链接：https://www.f2er.com/oracle/213660.html