oracle concat

oracle 连接字符串：

连接两个字符串

select concat('man','jia') from dual
select concat(username,password) from login ;

连接三个字符串
select concat((select concat('wo','shi') from dual),'abin') from dual
select 'abin'||'is'||'me' from dual
select username||password||username||password from login