create table CUSTOMERS
(
CUST_ID NUMBER(5),
CUST_LAST_NAME VARCHAR2(10),
COUNTRY_ID NUMBER(5)
);
insert into CUSTOMERS (CUST_ID, CUST_LAST_NAME, COUNTRY_ID)
values (1, 'jane', 10);
insert into CUSTOMERS (CUST_ID, CUST_LAST_NAME, COUNTRY_ID)
values (2, 'hanmeimei', 20);
insert into CUSTOMERS (CUST_ID, CUST_LAST_NAME, COUNTRY_ID)
values (3, 'lily', 30);
commit;
SELECT * FROM customers;
FROM customers
WHERE country_id=10
UNION
SELECT cust_id cust_no,cust_last_name
FROM customers ActualTests
WHERE country_id=30
ORDER BY 2,1;
SELECT cust_id,cust_last_name "Last Name"
FROM customers
WHERE country_id=10
UNION
SELECT cust_id cust_no,cust_last_name
FROM customers ActualTests
WHERE country_id=30
ORDER BY 2,cust_id;
SELECT cust_id,cust_last_name "Last Name"
FROM customers
WHERE country_id=10
UNION
SELECT cust_id cust_no,cust_last_name
FROM customers ActualTests
WHERE country_id=30
ORDER BY "Last Name";
以上三个的结果都是:
FROM customers
WHERE country_id=10
UNION
SELECT cust_id cust_no,cust_last_name
FROM customers ActualTests
WHERE country_id=30
ORDER BY cust_no;
SELECT cust_id,cust_last_name "Last Name"
FROM customers
WHERE country_id=10
UNION
SELECT cust_id cust_no,cust_last_name
FROM customers ActualTests
WHERE country_id=30
ORDER BY "cust_no";
以上两个的结果都是:
DROP TABLE customers;
SELECT * FROM customers;
FLASHBACK table customers to before drop;
SELECT * FROM customers;
alter table customers DISABLE row movement;(系统原本是开启的,我修改成不可用以便进行测试)
UPDATE customers SET cust_last_name='lilei' WHERE cust_id=2;
COMMIT;
flashback table customers to TIMESTAMP systimestamp - interval '2' minute;
SELECT * FROM customers;
alter table customers enable row movement; (闪回表必须要开启行移动功能!)
UPDATE customers SET cust_last_name='hanmeimei' WHERE cust_id=2;
COMMIT;
flashback table customers to TIMESTAMP systimestamp - interval '1' minute;
SELECT * FROM customers;
DROP TABLE customers;
select * from user_recyclebin;
FLASHBACK table customers to before drop;
drop table customers purge;
FLASHBACK table customers to before drop;