"" SQL> select 'aaa' as date from dual; select 'aaa' as date from dual * ERROR 位于第 1 行: ORA-00923: 未找到预期 FROM 关键字 已用时间: 00: 00: 00.60 SQL> select 'aaa' as "date" from dual;dat --- aaa已用时间: 00: 00: 00.20 SQL>
insert into (www,"date") values (1,'222') ;这样即可! 如果用语句生成,就必须要用'''date'''
有点不是很明白,以下是我建表的脚本: CREATE TABLE "OPERLOG"("ID" NUMBER(12) NOT NULL,"TIME" DATE DEFAULT SYSDATE,"COMPUTER" VARCHAR2(16),"USER" VARCHAR2(24), "EVENT" NUMBER(4),"TOPERATION" NUMBER(4),"TWAY" NUMBER(4),"OBJECT" VARCHAR2(24), PRIMARY KEY("TIME","COMPUTER","USER","EVENT","TOPERATION","TWAY","OBJECT")) TABLESPACE "XLTCOM"我想插入一条记录,问题出在user字段,现在的情况是字段不能改,我加了双引号插入不行:insert into operlog ("user",........) values ('hello',......)这样不行,应该怎么写?
SQL> create table test_1("user" varchar2(20));表被创建SQL> desc test_1; Name Type Nullable Default Comments ---- ------------ -------- ------- -------- user VARCHAR2(20) Y SQL> insert into test_1(user) values ('sdf');insert into test_1(user) values ('sdf')ORA-00928: missing SELECT keywordSQL> insert into test_1("user") values ('sdf');1 行 已插入SQL> commit;提交完成SQL> select * from test_1;user -------------------- sdfSQL> insert into test_1("user") values('SDF');1 行 已插入SQL> COMMIT;提交完成SQL> SELECT * FROM TEST_1;user -------------------- sdf SDFSQL>
这样只有一个字段是可以的,我看过了,在数据库中该字段其实是 "user", 带引号的。 但是用我的方法创建的字段是 user ,不带引号的。这样就不行了。
SQL> select 'aaa' as date from dual;
select 'aaa' as date from dual
*
ERROR 位于第 1 行:
ORA-00923: 未找到预期 FROM 关键字
已用时间: 00: 00: 00.60
SQL> select 'aaa' as "date" from dual;dat
---
aaa已用时间: 00: 00: 00.20
SQL>
CREATE TABLE "OPERLOG"("ID" NUMBER(12) NOT NULL,"TIME" DATE DEFAULT SYSDATE,"COMPUTER" VARCHAR2(16),"USER" VARCHAR2(24),
"EVENT" NUMBER(4),"TOPERATION" NUMBER(4),"TWAY" NUMBER(4),"OBJECT" VARCHAR2(24),
PRIMARY KEY("TIME","COMPUTER","USER","EVENT","TOPERATION","TWAY","OBJECT"))
TABLESPACE "XLTCOM"我想插入一条记录,问题出在user字段,现在的情况是字段不能改,我加了双引号插入不行:insert into operlog ("user",........) values ('hello',......)这样不行,应该怎么写?
Name Type Nullable Default Comments
---- ------------ -------- ------- --------
user VARCHAR2(20) Y SQL> insert into test_1(user) values ('sdf');insert into test_1(user) values ('sdf')ORA-00928: missing SELECT keywordSQL> insert into test_1("user") values ('sdf');1 行 已插入SQL> commit;提交完成SQL> select * from test_1;user
--------------------
sdfSQL> insert into test_1("user") values('SDF');1 行 已插入SQL> COMMIT;提交完成SQL> SELECT * FROM TEST_1;user
--------------------
sdf
SDFSQL>
带引号的。
但是用我的方法创建的字段是 user ,不带引号的。这样就不行了。