作业帮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_seq
来源：学生作业帮助网 编辑：作业帮 时间：2024/05/13 06:23:07
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_seq
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
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_seq
if 判等 是不是用 ==