也就是说,我要用到这样一个查询语句: select count(*) from table1 where newsid=变量1我该如何编写含有上面语句的存储过程啊???????
procedure getcount(ID in number) is begin select count(*) from t end getcount
procedure getcount(ID out number) is i number; begin select count(*) into i from t where ID= ID; if i>0 then ID:=i; else ID:=0; end if; end getcount
楼上的基本没有问题,只是语法有个小错误,对新手会有不良影响:PROCEDURE getcount (ID OUT NUMBER) IS i NUMBER; BEGIN SELECT COUNT (*) INTO i FROM t WHERE ID = ID; IF i > 0 THEN ID := i; ELSE ID := 0; END IF; END getcount;
create or replace getcount (ID OUT NUMBER) IS i NUMBER; BEGIN SELECT COUNT (*) INTO i FROM t WHERE ID = ID; IF i > 0 THEN ID := i; ELSE ID := 0; END IF;
select count(*) from table1 where newsid=变量1我该如何编写含有上面语句的存储过程啊???????
procedure getcount(ID in number)
is
begin
select count(*) from t
end getcount
procedure getcount(ID out number)
is
i number;
begin
select count(*) into i from t where ID= ID;
if i>0 then
ID:=i;
else
ID:=0;
end if;
end getcount
IS
i NUMBER;
BEGIN
SELECT COUNT (*)
INTO i
FROM t
WHERE ID = ID; IF i > 0
THEN
ID := i;
ELSE
ID := 0;
END IF;
END getcount;
create or replace getcount
(ID OUT NUMBER)
IS
i NUMBER;
BEGIN
SELECT COUNT (*)
INTO i
FROM t
WHERE ID = ID; IF i > 0
THEN
ID := i;
ELSE
ID := 0;
END IF;