select concat(concat(concat(concat(ename,'''s sal is '),sal),','),
concat(concat(ename,'''s job is '),job))from emp;
结果:SCOTT's sal is 3000,SCOTT's job is ANALYST
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25333814/viewspace-689638/,如需转载,请注明出处,否则将追究法律责任。