name虽然为关键字,但是它可以作为字段名。直接查即可。 SQL> create table test (id number,name varchar2(16));表已创建。SQL> insert into test values (1,'ACMILAN');已创建 1 行。SQL> commit;提交完成。SQL> select id,name from test; ID NAME ---------- ---------------- 1 ACMILANSQL>
如果是关键字 select id,"case" from test 加双引号就成
name 不是oracle的关键字吧??
在oracle中,关键字是可以作为 字段名字的CREATE TABLE a ( f_id INT,TYPE VARCHAR2(20));INSERT INTO a VALUES (1,'测试1'); INSERT INTO a VALUES(1,'测试2'); INSERT INTO a VALUES (1,'测试3');SELECT * FROM a;SELECT f_id,TYPE FROM a;
SQL> create table test (id number,name varchar2(16));表已创建。SQL> insert into test values (1,'ACMILAN');已创建 1 行。SQL> commit;提交完成。SQL> select id,name from test; ID NAME
---------- ----------------
1 ACMILANSQL>
INSERT INTO a VALUES(1,'测试2');
INSERT INTO a VALUES (1,'测试3');SELECT * FROM a;SELECT f_id,TYPE FROM a;