摘要： --create sales table CREATE TABLE sales (trans_date DATE, cust_id INT, sales_amount NUMBER); --insert sale rows INSERT /*+ APPEND */ INTO SALES SELECT TRUNC(SYSDATE, 'year') + MOD(RO... 阅读全文