System.Data.OracleClient – Oracle Delete Record 使用方法

 
System.Data.OracleClient – Oracle Delete Record 使用方法
 

 
   private void OracleDeleteConnection()
   {
 
      String ConnectionString = "User Id=<User ID>;Password=<User Password>; Data Source=<Server IP>; Unicode=True";
      OracleConnection conn = new OracleConnection(ConnectionString);
      conn.Open();
 
      String SQLStatement = "DELETE FROM Test WHERE ID = 14";
 
      OracleCommand cmd = new OracleCommand(SQLStatement, conn);
      cmd.ExecuteNonQuery();
 
      conn.Dispose();
      cmd.Dispose();
      conn.Close();
 
   }