Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

differences between : INSERT /*+APPEND */ or INSERT /*+APPEND NOLOGINS*/

Tricampeon_1981Jan 31 2020 — edited Jan 31 2020

Good morning friends, I hope you have an excellent Friday day !!! , I would like to be able to make a query, I have several insert - select and some are with the INSERT /*+APPEND */

sentence and others with the /*+APPEND NOLOGINS*/sentence, and I would like to know what the difference is please

-- examples

INSERT /*+APPEND */

INTO TTRB_TL_INT_PAG

  (

     TL_ORD_LIQ_NUM_ORD               ,

     NUM_INT_PAG  

)

values

(

campo_1,

campo2

)

--examples 2

INSERT /*+APPEND NOLOGINS*/

INTO TTRB_TL_INT_PAG

  (

     TL_ORD_LIQ_NUM_ORD               ,

     NUM_INT_PAG                     

)

values

(

campo_1

campo2

)

This post has been answered by BluShadow on Jan 31 2020
Jump to Answer
Comments
Post Details
Added on Jan 31 2020
6 comments
767 views