Oracle中||表示字符串拼接,select '姓名:' || 'firstName' || 'lastName' from NAMELIST
sqlserver中+表示字符串拼接,select '姓名:' + 'firstName' + 'lastName' from NAMELIST
mySql中concat表示字符串拼接,select concat('姓名:' + 'firstName' + 'lastName')
Oracle中||表示字符串拼接,select '姓名:' || 'firstName' || 'lastName' from NAMELIST
sqlserver中+表示字符串拼接,select '姓名:' + 'firstName' + 'lastName' from NAMELIST
mySql中concat表示字符串拼接,select concat('姓名:' + 'firstName' + 'lastName')