oracle字符串拼接

oracle字符串拼接

EXEC SQL DECLARE cur_delaytransfer CURSOR FOR

                SELECT vc_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

                FROM tfundcurrent_net

                WHERE c_type = '851'

                AND   c_businflag = '804'

                AND   c_busincause = '235'

                AND   c_state = '2'

                AND   nvl(c_delayflag,'0') = 1

                AND   not exists (select 1 from tnorealtransfertime 

                            where c_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')

                            and rownum < 2);

 如果字符串都是数字的话，则可以直接比较大小写。