Oracle missing right parenthesis哪里缺少
来源:学生作业帮 编辑:搜搜考试网作业帮 分类:综合作业 时间:2024/08/05 15:51:01
Oracle missing right parenthesis哪里缺少
declare cunt number(8);
create_table_str varchar(1000);
create_sequence_str varchar(1000);
begin select count(1) into cunt from user_tables where table_name='T_DBENTITY_MYSESSION';
if (cunt=0) then
create_sequence_str:='create sequence sqc_T_DBEntity_MySession increment by 1 start by 1 nomaxvalue nocycle cache 10';create_table_str:='create table T_DBEntity_MySession ( M_ID int identity(1,1) primary key ,M_IP nvarchar(4000),M_Key nvarchar(4000),M_FirstTime datetime,M_LastTime datetime,M_Value nvarchar(4000),M_TimeOut int)'; EXECUTE IMMEDIATE create_table_str;EXECUTE IMMEDIATE create_sequence_str;end if; end;
ORA-00907:missing right parenthesis
ORA-06512:at line 1
declare cunt number(8);
create_table_str varchar(1000);
create_sequence_str varchar(1000);
begin select count(1) into cunt from user_tables where table_name='T_DBENTITY_MYSESSION';
if (cunt=0) then
create_sequence_str:='create sequence sqc_T_DBEntity_MySession increment by 1 start by 1 nomaxvalue nocycle cache 10';create_table_str:='create table T_DBEntity_MySession ( M_ID int identity(1,1) primary key ,M_IP nvarchar(4000),M_Key nvarchar(4000),M_FirstTime datetime,M_LastTime datetime,M_Value nvarchar(4000),M_TimeOut int)'; EXECUTE IMMEDIATE create_table_str;EXECUTE IMMEDIATE create_sequence_str;end if; end;
ORA-00907:missing right parenthesis
ORA-06512:at line 1
![Oracle missing right parenthesis哪里缺少](/uploads/image/z/15439111-7-1.jpg?t=Oracle+missing+right+parenthesis%E5%93%AA%E9%87%8C%E7%BC%BA%E5%B0%91)
if 判等 是不是用 ==
再问: 自己找到了 identity(1,1)是sqlserver写法,oracle 没有,去掉 自己找到了,start by 1,改 start with 1
再问: 自己找到了 identity(1,1)是sqlserver写法,oracle 没有,去掉 自己找到了,start by 1,改 start with 1
Oracle报错:missing right parenthesis什么问题?
lingo提示错误missing right parenthesis
Lingo 错误代码 12-(data missing right parenthesis)
lingo 提示错误:missing right parenthesis
【急】lingo程,为何提示错误missing right parenthesis
为什么这一步lingo提出我missing right parenthesis的错误 实在看不出
I only remain missing the right是什么意思
open parenthesis是什么意思
MISSING .
missing
matlab Error:Missing variable or function.哪里错了?
I feel like i'm always missing something Oh right,it'