使用||作为连接运算符
SQL> select ename||CHR(32)||CHR(32)||'WORK AS A '||job as msg from emp;
MSG
-------------------------------
SMITH WORK AS A CLERK
ALLEN WORK AS A SALESMAN
WARD WORK AS A SALESMAN
JONES WORK AS A MANAGER
MARTIN WORK AS A SALESMAN
BLAKE WORK AS A MANAGER
CLARK WORK AS A MANAGER
SCOTT WORK AS A ANALYST
KING WORK AS A PRESIDENT
TURNER WORK AS A SALESMAN
ADAMS WORK AS A CLERK
MSG
-------------------------------
JAMES WORK AS A CLERK
FORD WORK AS A ANALYST
MILLER WORK AS A CLERK
14 rows selected.
CHR(32)代表空格