【转】oracle中sql话语字符相连接的写法
【转】oracle中sql语句字符相连接的写法
错误的写法:
update yz_seqno set order_no = (tran_brch,4,8) + substr(to_char(plat_date,'yyyymmdd'),5,8) + substr(order_no,10,12)
正确的应该是:
update yz_seqno set order_no = (tran_brch,4,8) || substr(to_char(plat_date,'yyyymmdd'),5,8) || substr(order_no,10,12)