1* select 'select' test from dual SQL> /TEST ------ select很奇怪你为什么要用特定词! 没道理!!
要确认一下泥的这个'select'字段的大小写!如果是大写的话,如此: update aaa set "SELECT"=1; COMMIT; 应该是可行的~
这样呢,行吗? update aaa a set a.select = 1; commit;
这样写是肯定行的: update aaa set "SELECT"=1; COMMIT; 因为默认的字段名称是大写的
1. CREATE TABLE QQCALLCENTER."HUATEST" ("SELECT" CHAR(10) NOT NULL, "UPDATE" CHAR(10) NOT NULL, "INTO" CHAR(10) NOT NULL, "WHERE" CHAR(10) NOT NULL) ;2. CREATE VIEW vhuatest (a1,a2,a3,a4) AS select "SELECT","UPDATE","INTO","WHERE" from huatest3. select a1,a2,a3,a4 from vhuatest where A4 = 'd';....
SQL> /TEST
------
select很奇怪你为什么要用特定词! 没道理!!
update aaa set "SELECT"=1;
COMMIT;
应该是可行的~
update aaa a
set a.select = 1;
commit;
update aaa set "SELECT"=1;
COMMIT;
因为默认的字段名称是大写的