请看 SQL:
update jam_configuration t set t.file-dir-full-path = 'D:\nothing\wiki\upload'
报错:Error starting at line 1 in command:
update jam_configuration t set t.file-dir-full-path = 'D:\nothing\wiki\upload'
Error at Command Line:1 Column:33
Error report:
SQL Error: ORA-01747: invalid user.table.column, table.column, or column specification
01747. 00000 - "invalid user.table.column, table.column, or column specification"
*Cause:
*Action:但是改成:update jam_configuration t set 't.file-dir-full-path' = 'D:\nothing\wiki\upload'也不对的。
update jam_configuration t set t.file-dir-full-path = 'D:\nothing\wiki\upload'
报错:Error starting at line 1 in command:
update jam_configuration t set t.file-dir-full-path = 'D:\nothing\wiki\upload'
Error at Command Line:1 Column:33
Error report:
SQL Error: ORA-01747: invalid user.table.column, table.column, or column specification
01747. 00000 - "invalid user.table.column, table.column, or column specification"
*Cause:
*Action:但是改成:update jam_configuration t set 't.file-dir-full-path' = 'D:\nothing\wiki\upload'也不对的。
file-dir-full-path 你 desc 看一下表结构吧
set "file-dir-full-path" = 'D:\nothing\wiki\upload'
update jam_configuration t set "t.file-dir-full-path" = 'D:\nothing\wiki\upload'
update jam_configuration set "file-dir-relative-path" = '/jamwiki/wiki/upload/';Error starting at line 1 in command:
update jam_configuration set "file-dir-relative-path" = '/jamwiki/wiki/upload/'
Error at Command Line:1 Column:29
Error report:
SQL Error: ORA-00904: "file-dir-relative-path": invalid identifier
00904. 00000 - "%s: invalid identifier"
*Cause:
*Action:
你看你双引号里的file这个单词是蓝色的,说明双引号没起作用啊。注意一下切换到英文状态,看我的例子:
drop table test_yixl;
create table test_yixl
(key number(2),
"file-dir-relative-path" varchar2(100));insert into test_yixl values (1, 'd:/test/');
commit;
update test_yixl set "file-dir-relative-path" ='/jamwiki/wiki/upload/';
commit;
完全正确啊。
的单引号有问题
不加双引号,不分大小写,(其实是全大写)
如果有特殊字符、空格等,必须加双引号,区分大小写。其他标识也如此。
如:
select "MyTable"."Col1" from "MyTable";
select t1."Col1" from t1;
;具体可以查询数据字典:
SELECT * FROM user_tab_columns tc;
标示名称使用双引号(")
字符串使用单引号(')