Oracle.dataaccess [upd] Link

conn.Open(); OracleCommand cmd = new OracleCommand("SELECT first_name, last_name FROM employees WHERE department_id = :deptId", conn); cmd.Parameters.Add("deptId", OracleDbType.Int32).Value = 10;

conn.Open(); OracleTransaction tx = conn.BeginTransaction(); try OracleCommand cmd = conn.CreateCommand(); cmd.Transaction = tx; cmd.CommandText = "UPDATE accounts SET balance = balance - 100 WHERE id = 1"; cmd.ExecuteNonQuery(); cmd.CommandText = "UPDATE accounts SET balance = balance + 100 WHERE id = 2"; cmd.ExecuteNonQuery(); tx.Commit(); catch tx.Rollback(); throw; oracle.dataaccess

using (OracleConnection conn = new OracleConnection(connStr)) OracleCommand cmd = new OracleCommand("SELECT first_name