How Insert Many Records In One ExecuteNonQuery Oracle Table by C#

Question

How Execute More One In Oracle Table by C#

"

Insert into table values (1,'A')
Insert into table values (2,'Ab')
Insert into table values (3,'Ac')
Insert into table values (4,'At')
....
"

Answer 1

Your question is vague one. If you want a single query with many records to insert, try insert + select syntax:

Best way to do multi-row insert in Oracle?

in your case

     insert into MyTable(id, name) 
            select 1, 'A'  from dual
  union all select 2, 'Ab' from dual
  union all select 3, 'Ac' from dual
  union all select 4, 'At' from dual

If you want to combine several queries, try putting them into an anonymous block:

  begin
    insert into MyTable values (1,'A');
    insert into MyTable values (2,'Ab');
    insert into MyTable values (3,'Ac');
    insert into MyTable values (4,'At');
    ...
  end;