我想把下面sql句结果赋给一个变量,我用下面的方法报什么“缺少表达式”的错误,
请问这种情况怎么用啊?v_sql := 'select count(*) into v_count1 From subject'
Execute Immediate v_sql3;
If v_count1 = 0 Then
....
end if;
请问这种情况怎么用啊?v_sql := 'select count(*) into v_count1 From subject'
Execute Immediate v_sql3;
If v_count1 = 0 Then
....
end if;
v_sql := 'select count(*) into v_count1 From subject';
declare
count1: int;
begin
execute immediate 'select count(*) From subject' into v_count1 ;
end;