(1) [SQLD]5์ฅ ๊ณ ๊ธ SQL ํ๋ (1) ๊ณ ๊ธ SQL ํ์ฉ
(2) [SQLP]5์ฅ ๊ณ ๊ธ SQL ํ๋ (2) ์ํธํ๋
(3) [SQLP]5์ฅ ๊ณ ๊ธ SQL ํ๋ (3) DML ํ๋
(4) [SQLP]5์ฅ ๊ณ ๊ธ SQL ํ๋ (4) ํํฐ์
ํ์ฉ
(5) [SQLP]5์ฅ ๊ณ ๊ธ SQL ํ๋ (5) ๋ฐฐ์น ํ๋ก๊ทธ๋จ ํ๋
(1) [SQLPํ๊ธฐํ์ด]6์ฅ ๊ณ ๊ธSQLํ๋(1)-์ํธํ๋
(2) [SQLPํ๊ธฐํ์ด]6์ฅ ๊ณ ๊ธSQLํ๋(2)DML ํ๋
(3) [SQLPํ๊ธฐํ์ด]6์ฅ ๊ณ ๊ธSQLํ๋(3)๋ฐ์ดํฐ๋ฒ ์ด์ค Call ์ต์ํ
alter table t NOLOGGING;
CREATE TABLE T1 NOLOGGING
AS SELECT ~
ALTER TABLE AA NOLOGGING;
ALTER TABLE AA NOLOGGING;
INSERT /*+ append */ INTO AA
SELECT * FROM BB;
ALTER SESSION ENABLE PARALLEL DML;
INSERT /*+ parallel(AA, 4) */ INTO AA
SELECT * FROM BB;