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/07/12 04:01:44
![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](/uploads/image/z/13479454-46-4.jpg?t=Oracle+missing+right+parenthesis%E5%93%AA%E9%87%8C%E7%BC%BA%E5%B0%91declare+cunt+number%288%29%3B+create_table_str+varchar%281000%29%3Bcreate_sequence_str+varchar%281000%29%3Bbegin+select+count%281%29+into+cunt+from+user_tables+where+table_name%3D%27T_DBENTITY_MYSESSION%27%3B+if+%28cunt%3D0%29+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_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 判等 是不是用 ==