动态sql?execute immediate 'select count(1) into va_LOGIN_TOTALNUM from '||va_member_code||'.op_log op where op.optype = '登录' and to_char(createtime, 'yyyy') = to_char(sysdate, 'yyyy')' into va_LOGIN_TOTALNUM;
v_sql:='sql statement'; execute immediate v_sql into v_param;eg: SQL> declare v_par1 varchar2(100); 2 v_sql varchar2(1000); 3 v_ename varchar2(20):='scott.emp'; 4 begin 5 v_sql:='select ename from '||v_ename||' where empno=7788'; 6 execute immediate v_sql into v_par1; 7 dbms_output.put_line('v_par1:='||v_par1); 8 end; 9 / v_par1:=SCOTT
into va_LOGIN_TOTALNUM
from '||va_member_code||'.op_log op
where op.optype = '登录'
and to_char(createtime, 'yyyy') = to_char(sysdate, 'yyyy')'
into va_LOGIN_TOTALNUM;
execute immediate v_sql into v_param;eg:
SQL> declare v_par1 varchar2(100);
2 v_sql varchar2(1000);
3 v_ename varchar2(20):='scott.emp';
4 begin
5 v_sql:='select ename from '||v_ename||' where empno=7788';
6 execute immediate v_sql into v_par1;
7 dbms_output.put_line('v_par1:='||v_par1);
8 end;
9 /
v_par1:=SCOTT