请输入专案类型(网站专案或者应用程式专案)：VB.NET
程式码如下:
OracleSql = "DELETE FROM table WHERE columnnsA IN ('aa','bb')"
OracleCmd = New OleDbCommand(OracleSql, OracleConn)
OracleCmd.ExecuteNonQuery()
OracleSql = "COMMIT"
OracleCmd = New OleDbCommand(OracleSql, OracleConn)
OracleCmd.ExecuteNonQuery()
OracleSql = "DELETE FROM table WHERE columnsB <> 'CK'"
OracleCmd = New OleDbCommand(OracleSql, OracleConn)
OracleCmd.ExecuteNonQuery()
OracleSql = "COMMIT"
OracleCmd = New OleDbCommand(OracleSql, OracleConn)
OracleCmd.ExecuteNonQuery()
Catch ex As Exception
WirteLog(ex.ToString)
Finally
OracleCmd.Dispose() << 这行执行会有问题!!
OracleConn.Close()
OracleConn.Dispose()
End Try
DELETE可以这样下指令吗? Oracle数据库 VB.NET
我修改了N次后这样子不会出现字符无效 但是不会出现程式接口..