在Oracle SQL Developer运行sql语句一直报错 ORA-00936:missing expression
select * from tpvframe_publication WHERE number=1;
是number类的给值有什么规范?表结构如下:CREATE TABLE "PLMWFLOW"."TPVFRAME_PUBLICATION"
( "NUMBER" NUMBER NOT NULL ENABLE,
"ISTOP" VARCHAR2(1 BYTE) NOT NULL ENABLE,
"DUEDATE" DATE NOT NULL ENABLE,
"SUBJECT" VARCHAR2(200 BYTE) NOT NULL ENABLE,
"CONTENT1" VARCHAR2(4000 BYTE) NOT NULL ENABLE,
"CONTENT2" VARCHAR2(4000 BYTE),
"PUBLISHDATE" DATE NOT NULL ENABLE,
CONSTRAINT "TPVFRAME_PUBLICATION_PK" PRIMARY KEY ("NUMBER")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ENABLE
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
select * from tpvframe_publication WHERE number=1;
是number类的给值有什么规范?表结构如下:CREATE TABLE "PLMWFLOW"."TPVFRAME_PUBLICATION"
( "NUMBER" NUMBER NOT NULL ENABLE,
"ISTOP" VARCHAR2(1 BYTE) NOT NULL ENABLE,
"DUEDATE" DATE NOT NULL ENABLE,
"SUBJECT" VARCHAR2(200 BYTE) NOT NULL ENABLE,
"CONTENT1" VARCHAR2(4000 BYTE) NOT NULL ENABLE,
"CONTENT2" VARCHAR2(4000 BYTE),
"PUBLISHDATE" DATE NOT NULL ENABLE,
CONSTRAINT "TPVFRAME_PUBLICATION_PK" PRIMARY KEY ("NUMBER")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ENABLE
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "USERS" ;
解决方案 »
- 请教行转列问题
- 模式是什么意思?不明白这个词是什么意思,里面有一段话..
- 请问谁有比help workshop 更好的编辑帮助文挡的工具,要能够识别中文的!
- 菜鸟问个联合查询问题
- OMS查找到了节点,确找不到节点里的实例,请问如何解决
- oracle8i中的oracle management server是什么东西?
- 在线等,如何打开监听,为何报the listener supports no services
- 如何用jsp向oracle9i中存储并提取图片显示在web页面中?
- 【讨论】如何自动更改SQLPLUS的提示符?
- 我的oracle怎么无缘无故的出现以下错误啊:
- 登录oracle directory manager时提示服务器未启动和运行
- vc oracle pro*c环境配置好了之后,工具怎么用?
改为:
select * from tpvframe_publication WHERE "number"=1;