使用||作为连接运算符

SQL> select ename||CHR(32)||CHR(32)||'WORK AS A '||job as msg from emp;MSG-------------------------------SMITH  WORK AS A CLERKALLEN  WORK AS A SALESMANWARD  WORK AS A SALESMANJONES  WORK AS A MANAGERMARTIN	WORK AS A SALESMANBLAKE  WORK AS A MANAGERCLARK  WORK AS A MANAGERSCOTT  WORK AS A ANALYSTKING  WORK AS A PRESIDENTTURNER	WORK AS A SALESMANADAMS  WORK AS A CLERKMSG-------------------------------JAMES  WORK AS A CLERKFORD  WORK AS A ANALYSTMILLER	WORK AS A CLERK14 rows selected.

CHR(32)代表空格