oracle笔记
时间:2022-03-16 10:52
1)|| 符号
说明:字符串连接符号
select max(ZDSXH)+1 zdh from bdczddm where djzqdm||zdsyqlx||zdtzm=‘" + zddd + "‘View Code
--Á¬½Ó×ֶΠSQL> select ‘ABC‘||‘EFG‘ from dual; ‘ABC‘||‘EFG‘ ------------ ABCEFG Ò²¿ÉÒÔʹÓÃconcat()º¯Êý select concat(‘A‘,‘B‘) from dual;View Code