oracle笔记
1)|| 符号
说明:字符串连接符号
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
select max(ZDSXH)+1 zdh from bdczddm where djzqdm||zdsyqlx||zdtzm='" + zddd + "'
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
--Á¬½Ó×ֶΠSQL> select 'ABC'||'EFG' from dual; 'ABC'||'EFG' ------------ ABCEFG Ò²¿ÉÒÔʹÓÃconcat()º¯Êý select concat('A','B') from dual;