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