Oracle c# multiple update sql

string sql1 = "BEGIN update Table1 set name = 'joe' where id = 10;",
       sql2 = "update Table2 set country = 'usa' where region = 'americas';",
       sql3 = "update Table3 set weather = 'sunny' where state = 'CA';",
       sql4 = "update Table4 set engine = 'v8' where maker = 'benz'; END;";

string sql = string.Format("{0}{1}{2}{3}",sql1,sql2,sql3,sql4);

using (OracleConnection conn = new OracleConnection())
using (OracleCommand cmdUpdate = new OracleCommand(sql, conn))
{
    conn.Open();
    recs = cmdUpdate.ExecuteNonQuery();
}

Source: stackoverflow.com

Similar codes

1 vote103 views1 answer
Sql server select rows by distinct column
SQL
0 vote110 views1 answer
Drop a field in psql django
SQL
-1 vote109 views1 answer
Mac mysql workbench console
SQL
1 vote128 views1 answer
Show databases mysql docker
SQL
1 vote124 views1 answer
Code: "ER_TRUNCATED_WRONG_VALUE", errno: 1292, sqlMessage: "Incorrect date value: '2021-03-20T18:30:00.000Z' for column 'mgfdate' at row 1", sqlState: "22007", index: 0, …}
SQL
-1 vote109 views1 answer
Get id from just inserted row mysql server python
SQL
0 vote112 views1 answer
Install squirrel sql ubuntu
SQL
0 vote119 views1 answer
Get date from timestamp in mysql
SQL
0 vote108 views1 answer
Sql server: how to assign value to table variable returned from function
SQL
0 vote61 views1 answer
Delete all rows from table sqlite
SQL