search

NorthConcepts / DataPipeline-Examples

DataPipeline Examples
Apache License 2.0
17 stars 5 forks source link

DP-3054_Insert multiple rows together to an oracle table using insert all #160

Closed yaphet17 closed 1 year ago

yaphet17 commented 1 year ago

Neither HSQLDB nor H" support INSERT ALL syntax so I didn't use them in this example.

DeleTaylor commented 1 year ago

Neither HSQLDB nor H" support INSERT ALL syntax so I didn't use them in this example.

I'm not sure what you mean -- this is an Oracle example not HSQL or H2 -- can you elaborate?

yaphet17 commented 1 year ago

I used H2 database for OracleMultiRowSelectUnionAllStatementInsert and I was trying to use it for this example also so that a user can just run it without setting up anything.

I updated it to use a real oracle database now. Sorry for the confusion.