在用PowerDesigner生成oracle数据库时怎么会是这个样的呢
create table "Category" (
ID INTEGER not null,
"CateName" VARCHAR2(40),
"CateDesc" CLOB
);问题:表名"Category" 不应该有引号;
数据类型:integer有错;
这样解决?
create table "Category" (
ID INTEGER not null,
"CateName" VARCHAR2(40),
"CateDesc" CLOB
);问题:表名"Category" 不应该有引号;
数据类型:integer有错;
这样解决?
SQL> CREATE TABLE "CATEGORY" (
2 ID INTEGER NOT NULL,
3 "CATENAME" VARCHAR2(40),
4 "CATEDESC" CLOB
5 );Table createdSQL> SELECT * FROM CATEGORY; ID CATENAME CATEDESC
---------- -------------------- ----------------------
create table Category (
ID INTEGER not null,
CateName VARCHAR2(40),
CateDesc CLOB
);
create table "Category" (
ID INTEGER not null,
"CateName" VARCHAR2(40),
"CateDesc" CLOB
);
查询时要用 select * from "category";
而一般建的表都是select * from category就可以了,还有oracle 里面不支持Integer数据类型。