字符串连接符

 || 在Java中是或的意思,但在Oracle中是拼接的意思

--拼接字符串
select 'Hello'||'world' from dual;
select 'Hello'||'1234'from dual;
select '123'||999 from dual;

select '100'+'200' from dual;

 

原文地址:https://www.cnblogs.com/q827418266/p/5797576.html