1 字符连接
SQL> select '111' || '222' 连接, empno,ename,job
2 from emp;
连接 EMPNO ENAME JOB
------------ ---------- -------------------- ------------------
111222 7369 SMITH CLERK
111222 7499 ALLEN SALESMAN
111222 7521 WARD SALESMAN
111222 7566 JONES MANAGER
111222 7654 MARTIN SALESMAN
111222 7698 BLAKE MANAGER
111222 7782 CLARK MANAGER
111222 7788 SCOTT ANALYST
111222 7839 KING PRESIDENT
111222 7844 TURNER SALESMAN
111222 7876 ADAMS CLERK
111222 7900 JAMES CLERK
111222 7902 FORD ANALYST
111222 7934 MILLER CLERK
说明:select语句检索列可以来自于任何地方,实际上,如果查询的内容与业务表没有任何关系时,我们可以用虚表
SQL> select '111'||'222' 连接 from dual;
连接
------------
111222