oracle笔记

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

 

oracle笔记

标签：