-21 6-21 ' as col from dualselect '6-20 6-20 6-20 6-20 6-20 ' from dualselect '6-9 6-96-96-96-96-96-9 ' from dual)Mon: 6-21, Tue: 6-21, Wed: 6-21, Thu: 6-21, Fri: 6-21, S
我明白了,这是因为系统认为我试图更新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
在一列中,我有"1;2;3;6-9“ 我需要将这个字符串放在这样的数组中(1,2,3,6,7,8,9) select range from my_table 返回 | range || 1;2;3;6-9 | 我需要跑步 select id from my_another_table where id in("1;2;3;6-9") | id |
|----|