/* CONCAT只能连接两个字符串 The syntax for the concat function is : concat( string1, string2 ) string1 is the first string to concatenate. string2 is the second string to concatenate. */ --||可以连接多个字符串 SQL> select concat( 'CSDN' , '_yeeXun' ) from dual; CONCAT( 'CSDN' , '_YEEXUN' ) ------------------------ CSDN_yeeXun SQL> select 'CSDN' || '_yeeXun' from dual; 'CSDN' || '_YEEXUN' ----------------- CSDN_yeeXun SQL> select concat( 'CSDN' , '_yeeXun' , 'china' ) from dual; select concat( 'CSDN' , '_yeeXun' , 'china' ) from dual ORA-00909: invalid number of arguments SQL> select 'CSDN' || '_yeeXun' || 'china' from dual; 'CSDN' || '_YEEXUN' || 'CHINA' -------------------------- CSDN_yeeXunchina