sqlserver 、Oracle、pgsql 差异

1.拼接字符

sqlserver  +

select fristName+lastName as fullName from User

oracle   ||

select fristName||lastName as fullName from User

pgsql    ||

select fristName||lastName as fullName from User