oracle 11g新特性

数据运维 2023-09-07 法医 手机阅读

ALTER SESSION ENABLE PARALLEL DML; UPDATE orders SET order_date = SYSDATE WHERE order_id >10 AND order_id

CREATE TABLE orders_temp AS SELECT * FROM orders WHERE order_id >30; EXPLAIN PLAN FOR INSERT INTO orders SELECT * FROM orders_temp; SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY());