Forum Discussion

Szymon's avatar
Szymon
New Contributor II
5 years ago
Solved

Oracle Insert - multiple rows in transaction possible?

Hi, How to insert multiple rows at a time into Oracle table within one transaction? Example: Reading 10 lines from CSV/Excel file. Insert 10 lines into Oracle using Oracle insert. When one ...
  • Aleksandar_A's avatar
    Aleksandar_A
    2 years ago

    Hello moizB,

    Please refer to the attached pipeline and let me know if it helps you in achieving the desired output structure.

     

    Regards,

    Aleksandar.

igormicev's avatar
igormicev
Contributor
5 years ago

Hi @Szymon,

  1. The harder way:
    If it’s literally 10, 20, or even 100s of rows you can dynamically build an INSERT INTO … VALUES()… pl/sql string and execute it with the Oracle - Execute snap. But if it’s thousands oF rows or even more, then you can store the temporary data into a temp table and then apply the BEGIN … COMMIT/ROLLBACK again with an Oracle - Execute snap.

  2. The easier way 🙂
    But, maybe you’re seeking this option in a snap (Oracle - Bulk Load):

/Igor

  • Szymon's avatar
    Szymon
    New Contributor II
    5 years ago

    Thank you Igor.

    1. yes, thought of that, but i would like to avoid execute snap, since this is just a kind of error prone, if i need to build insert statements manually.
    2. saw this option too, right now the sqlldr does not work properly, so cannot say, if that is an option.
      Again, thank you very much for confirming the options.
      I almost thought i might have missed some useful feature 😆
      cheers
      Simon