insert multiple rows in table

[akash16]

Hi All,

In my code, I have a std::list of objects those I need to insert into a oracle table.

What I can think now is writing an insert statement in a loop.

Anyone, please help me to understand other efficient way to insert multiple rows?

[Ganado]

This sounds more like a SQL question, not a C++ question? Correct me if I'm wrong.

You can insert up to 1000 rows at a time if you build up your SQL statement:
https://www.sqlservertutorial.net/sql-server-basics/sql-server-insert-multiple-rows/

If you're talking about building the string itself, simple str += concatenation should do.