一、閃回查詢

20:55:03 SQL> select * from emp1;

EMPNO ENAME????? JOB????????????? MGR HIREDATE??????????? SAL?????? COMM???? DEPTNO

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

7369 SMITH????? CLERK?????????? 7902 17-DEC-80?????????? 800??????????????????? 20

7499 ALLEN????? SALESMAN??????? 7698 20-FEB-81????????? 1600??????? 300???????? 30

7521 WARD?????? SALESMAN??????? 7698 22-FEB-81????????? 1250??????? 500???????? 30

7566 JONES????? MANAGER???????? 7839 02-APR-81????????? 2975??????????????????? 20

7654 MARTIN???? SALESMAN??????? 7698 28-SEP-81????????? 1250?????? 1400???????? 30

7698 BLAKE????? MANAGER???????? 7839 01-MAY-81????????? 2850??????????????????? 30

7782 CLARK????? MANAGER???????? 7839 09-JUN-81????????? 2450??????????????????? 10

7788 SCOTT????? ANALYST???????? 7566 19-APR-87????????? 3000??????????????????? 20

7839 KING?????? PRESIDENT??????????? 17-NOV-81????????? 5000??????????????????? 10

7844 TURNER???? SALESMAN??????? 7698 08-SEP-81????????? 1500????????? 0???????? 30

7876 ADAMS????? CLERK?????????? 7788 23-MAY-87????????? 1100??????????????????? 20

EMPNO ENAME????? JOB????????????? MGR HIREDATE??????????? SAL?????? COMM???? DEPTNO

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

7900 JAMES????? CLERK?????????? 7698 03-DEC-81?????????? 950??????????????????? 30

7902 FORD?????? ANALYST???????? 7566 03-DEC-81????????? 3000??????????????????? 20

7934 MILLER???? CLERK?????????? 7782 23-JAN-82????????? 1300??????????????????? 10

14 rows selected.

總結

以上是生活随笔為你收集整理的oracle闪回特性,oracle闪回特性的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。