我明白了,这是因为系统认为我试图更新ORACLE_USER表。不管怎么说,这附近有吗?UPDATESELECTFROMJOIN IFSAPP.ORACLE_ACCOUNT oaoa.USERNAMEJOIN IFSAPP.table2 up ut.oracle_user = up.user_name up.default_value <> '11'
AND oa
[OA_ID] FROM [Operating_Authority_Table] WHERE [OA_Name] = [@OA_Name]";
但是,当我将“@OA_Name”更改为在表中找到的简单值时command.CommandText = "SELECT [OA_ID] FROM [Operating_Authority_Table] WHERE [OA_Name] = ['OA 101']";] FROM [Op
我正在使用Oracle示例:2) 1,2,3,5,11第一个例子是我遇到的问题。我正在编写一个select查询,如: SELECT * from Table where Value IN (1,2,3,6-8,9-11)SELECT * from Table where Value IN (1,2,3,6,7,8,9,10,11)将解决我的问题