SQL> CREATE TABLE "Employees" (
2 "EmployeeID" INTEGER NOT NULL,
3 "LastName" NVARCHAR2(20) NOT NULL,
4 "FirstName" NVARCHAR2(10) NOT NULL,
5 "Title" NVARCHAR2(30),
6 "TitleOfCourtesy" NVARCHAR2(25),
7 "BirthDate" DATE,
8 "HireDate" DATE,
9 "Address" NVARCHAR2(60),
10 "City" NVARCHAR2(15),
11 "Region" NVARCHAR2(15),
12 "PostalCode" NVARCHAR2(10),
13 "Country" NVARCHAR2(15),
14 "HomePhone" NVARCHAR2(24),
15 "Extension" NVARCHAR2(4),
16 "Photo" BLOB,
17 "Notes" NCLOB,
18 "ReportsTo" INTEGER,
19 "PhotoPath" NVARCHAR2(255)
20 )
21 /表已创建。SQL> select * from Employees;
select * from Employees
*
第 1 行出现错误:
ORA-00942: table or view does not exist
2 "EmployeeID" INTEGER NOT NULL,
3 "LastName" NVARCHAR2(20) NOT NULL,
4 "FirstName" NVARCHAR2(10) NOT NULL,
5 "Title" NVARCHAR2(30),
6 "TitleOfCourtesy" NVARCHAR2(25),
7 "BirthDate" DATE,
8 "HireDate" DATE,
9 "Address" NVARCHAR2(60),
10 "City" NVARCHAR2(15),
11 "Region" NVARCHAR2(15),
12 "PostalCode" NVARCHAR2(10),
13 "Country" NVARCHAR2(15),
14 "HomePhone" NVARCHAR2(24),
15 "Extension" NVARCHAR2(4),
16 "Photo" BLOB,
17 "Notes" NCLOB,
18 "ReportsTo" INTEGER,
19 "PhotoPath" NVARCHAR2(255)
20 )
21 /表已创建。SQL> select * from Employees;
select * from Employees
*
第 1 行出现错误:
ORA-00942: table or view does not exist
等 级:
发表于:2007-11-08 14:52:271楼 得分:0
你把所有的 "都去掉就好了。
对了,能说为什么吗???
只要去掉"Employees"的双引号就可以了。
你的错误在于,因为你创建Employees表时用了双引号,所以,此表在数据字典中就用Employees保存。
而select * from Employees该语句中,Employees这几个字符会被转化为大写,然后在数据字典中进行查找,而在字典中,Employees<>EMPLOYEES,这就会出现ORA-00942: table or view does not exist的错误,指明找不到该表。
k6400明白了,看样子oracle的东西很深奥
select 的字段中去掉BLOB字段就可以了,