create or replace procedure Proc_Get_MLTInputData(startdate in date,enddate in date)
as
begin
select Unitsinfoname,Productsname,CreateDate,nvl(CheckValues,Readvales) as value from RawMeteringChamber
where CreateDate>=startdate and CreateDate<=enddate;
end
------解决方案--------------------
建议看看ORACLE存储过程的基础.
http://blog.csdn.net/edcvf3/article/details/7844575 参考一下