v_num number;select count(*) into v_num from XB_FK_CCXX_FROM_AJ select count(*) from XB_FK_CCXX_FROM_AJ into v_num
这2张有什么区别吗,为什么我第一就不行,第二个就可以,,现在我就想在后面加一个现在语句,老是不行select count(*) into v_num from XB_FK_CCXX_FROM_AJ where thbz=××;
这2张有什么区别吗,为什么我第一就不行,第二个就可以,,现在我就想在后面加一个现在语句,老是不行select count(*) into v_num from XB_FK_CCXX_FROM_AJ where thbz=××;
标准的是第一个呀
select count(*) into v_num from XB_FK_CCXX_FROM_AJ
create or replace procedure prc_test(deptno in number)
is
vi_deptno number;
v_num number;
begin
vi_deptno := deptno;
select count(*) into v_num from scott.dept t
where t.deptno = vi_deptno;
--select count(*) from scott.dept into v_num;
end;
前面的没报错啊,你的报什么错误