- Forum
- General C++ Programming
- insert multiple rows in table
insert multiple rows in table
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?
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?
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.
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.
Last edited on
Topic archived. No new replies allowed.