1.create procedure proj_1(v_num out number) as
v_pro varchar2(20)
begin
select sum(cast(info as int(20)))/100 into v_num from 表名 where bi=v_pro;
end;
/*不懂你这是什么,我照抄sum(cast(info as int(20)))/100 */2.select decode(a.qq,'YES','是'),a.ww, b.aa,b.ss,
from a.rr=b.ff
v_pro varchar2(20)
begin
select sum(cast(info as int(20)))/100 into v_num from 表名 where bi=v_pro;
end;
/*不懂你这是什么,我照抄sum(cast(info as int(20)))/100 */2.select decode(a.qq,'YES','是'),a.ww, b.aa,b.ss,
from a.rr=b.ff
create or replace procedure tes(aa in varchar)
as
Vsql varchar2(100);
begin
Vsql:='select sum(to_number(b)) a from t1 where a='||aa;
dbms_out
execute immediate Vsql;
end;
/2:
select
decode(a.qq,'YES','是'),a.ww,b.aa,b.ss
from a,b
where a.rr=b.ff;
需要用ref cursor来返回。
这个跟sql server不同。
搜索“结果集”
2.select decode(a.qq,'YES','是'),a.ww, b.aa,b.ss,
from a, b
where a.rr=b.ff;
create or replace procedure proj_1(aa in varchar2)
begin
select sum(to_number(info))/100 from 表名 where bi = aa;
end;