lq_bc的专栏

SELECT * FROM( SELECT ROWNUM NUM, E.EMPNO, E.ENAME, E.JOB, E.DEPTNO, (SELECT T.DNAME FROM DEPT T WHERE T.DEPTNO=E.DEPTNO) DNMAE FROM EMP E ...

SELECT TO_CHAR(ADD_MONTHS(SYSDATE, -2), 'YYYYMM') MON FROM DUAL WHERE [color=red]EXISTS [/color](SELECT 1 FROM DUAL WHERE TO_CHAR(SYSDATE, 'DD') < '09') [color=red]UNION[/color] SELECT TO_CHAR(...