APPEND hint placement for an INSERT INTO statement
APPEND hint for the INSERT INTO statement.
Are the below statements correct for a valid insert statement with APPEND hint?
1. INSERT /*+APPEND */ INTO table_name SELECT * FROM SUB_TABLE;
2. INSERT INTO /*+APPEND */ table_name SELECT * FROM SUB_TABLE;
3. INSERT INTO table_name SELECT /*+APPEND */ * FROM SUB_TABLE;
4. INSERT /*+APPEND */ INTO table_name VALUES(...........);
5. INSERT INTO /*+APPEND */ table_name VALUES(...........);
Please provide your comments on the above.
Are the below statements correct for a valid insert statement with APPEND hint?
1. INSERT /*+APPEND */ INTO table_name SELECT * FROM SUB_TABLE;
2. INSERT INTO /*+APPEND */ table_name SELECT * FROM SUB_TABLE;
3. INSERT INTO table_name SELECT /*+APPEND */ * FROM SUB_TABLE;
4. INSERT /*+APPEND */ INTO table_name VALUES(...........);
5. INSERT INTO /*+APPEND */ table_name VALUES(...........);
Please provide your comments on the above.
0