边学边写,琐碎记载oracle

 1、如何让列名中间含有空格
SELECT ENAME || ',' || ' ' || JOB "Employee and Title" FROM EMP;
2、按照多个关键字排列
SELECT ENAME, SAL, COMM FROM EMP ORDER BY SAL DESC,comm DESC;
posted @ 2012-02-22 19:50  java简单例子  阅读(103)  评论(0编辑  收藏  举报