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

4 votes153 views4 answers
Remove duplicate old value in mysql
SQL
0 vote134 views1 answer
Mysql count with two joins
SQL
0 vote117 views1 answer
Metada in sql
SQL
0 vote196 views1 answer
Sql delete row from table where id
SQL
16 votes136 views3 answers
Update table from another table
SQL
1 vote120 views1 answer
Check constraint to check if date greater than todays date
SQL
0 vote144 views1 answer
Sql server sleep
SQL
0 vote132 views1 answer
How to update rows from a table when certain conditions are met in mysql
SQL
11 votes133 views2 answers
Having in sql
SQL
0 vote122 views1 answer
Enable outgoing remote MySQL access
SQL