菜鸟问题——简单的Oracle语句,为何出错?
如下,birthday_tbl是表名,想把符合条件的记录数存到变量v_today_birth_maxno中去:
declare v_today_birth_maxno int;
begin
select count(*) into v_today_birth_maxno from birthday_tbl
where Substr(trans_id,1,6)=To_Char(sysdate,'YYMMDD');
dbms_output.put_line('v_today_birth_maxno='||to_char(v_today_birth_maxno));
end;