Oracle的回闪查询(二)

2014-11-24 18:16:57 · 作者: · 浏览: 1
t * from scott.emp where empno in(7788,7782,7698);




EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO


----- ---------- --------- ----- ----------- --------- --------- ------


7698 BLAKE MANAGER 7839 1981-5-1 4000.00 30


7782 CLARK MANAGER 7839 1981-6-9 4000.00 10


7788 SCOTT ANALYST 7566 1987-4-19 4000.00 20