create or replace procedure <proc_name> (参数A out 类型,参数B out 类型) is begin select a.b,c.d into 参数A,参数B from a,b where a.b1 = c=d1 and a.b2 = c=d2 and a.b3 = 1 and a.b4 like '12345'; end;
CREATE OR REPLACE PROCEDURE <proc_name> (parameter_list) IS BEGIN select a.b,c.d from a,b where a.b1 = c=d1 and a.b2 = c=d2 and a.b3 = 1 and a.b4 like '12345'; --这个是SQL语句得到一个结果集,要用到CURSOR去处理结果集,让C#程序调用 END;------------------------------------------------------------------ ORACLE DBA的QQ群:9610122 (欢迎加入!)
create or replace procedure <proc_name> (参数A out 类型,参数B out 类型)
is
begin
select a.b,c.d into 参数A,参数B from a,b
where a.b1 = c=d1 and a.b2 = c=d2 and a.b3 = 1 and a.b4 like '12345';
end;
CREATE OR REPLACE PROCEDURE <proc_name>
(parameter_list)
IS
BEGIN
select a.b,c.d from a,b where a.b1 = c=d1 and a.b2 = c=d2 and a.b3 = 1 and a.b4 like '12345';
--这个是SQL语句得到一个结果集,要用到CURSOR去处理结果集,让C#程序调用
END;------------------------------------------------------------------
ORACLE DBA的QQ群:9610122 (欢迎加入!)