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

0 vote249 views1 answer
Mysql join column order By and group By
SQL
4 votes225 views1 answer
Sql query to make a existing column auto increment
SQL
0 vote223 views1 answer
Order by ip address sql
SQL
0 vote243 views1 answer
Sql tabelle erstellen
SQL
11 votes226 views3 answers
Sqlite3 create table from another table
SQL
2 votes221 views1 answer
Sqlite indexes
SQL
0 vote232 views1 answer
Set classpath for mysql-connector.jar
SQL
0 vote249 views1 answer
Shows all databases created by user in ms sql
SQL
0 vote215 views1 answer
Postgresql regular expression special characters
SQL
2 votes234 views1 answer
Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
SQL