|| 在Java中是或的意思,但在Oracle中是拼接的意思
--拼接字符串
select 'Hello'||'world' from dual;
select 'Hello'||'1234'from dual;
select '123'||999 from dual;
select '100'+'200' from dual;
|| 在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