Oracle中如图怎么写存储过程

[过期的豆豆糖]

有这样一个业务怎么写存储过程

[勿勿]

图片没了

[过期的豆豆糖]

<form action="stcommoditysellinfo_findAll" method="post">
<table width="200" border="1">
<tr>
<td nowrap="nowrap">
分析日期：
</td>
<td nowrap="nowrap">
<input type="text" name="startDate" readOnly onClick=setDay(this);
value="2000-01-01">
</td>
<td nowrap="nowrap">
至
</td>
<td nowrap="nowrap">
<input type="text" name="stopDate" readOnly
onClick=setDay(this); value="2012-01-01">
</td>
</tr>
<tr>
<td nowrap="nowrap">
商品名称：
</td>
<td colspan="3" nowrap="nowrap">
<select id="select3" name="commodityname">
<c:forEach items="${list}" var="lv">
<option value="${lv[5]}">
${lv[5]}
</option>
</c:forEach>
</select>
</td>
</tr>
<tr>
<td nowrap="nowrap">
商品规格：
</td>
<td nowrap="nowrap">
<select name="commoditymodel" id="select4">

</select>
</td>
<td nowrap="nowrap">
业务员：
</td>
<td nowrap="nowrap">
<select name="employeename" id="select4">

</select>
</td>
</tr>
<tr>
<td nowrap="nowrap">
客户名称：
</td>
<td colspan="3" nowrap="nowrap">
<select name="customerName" id="select5">

</select>
</td>
</tr>
<tr>
<td nowrap="nowrap">
客户类型：
</td>
<td nowrap="nowrap">
<select name="customerType" id="select6">

</select>
</td>
<td nowrap="nowrap">
客户阶段：
</td>
<td nowrap="nowrap">
<select name="customerLevel" id="select6">
</select>
</td>
</tr>
<tr>
<td nowrap="nowrap">
客户级别：
</td>
<td nowrap="nowrap">
<select name="customerRank" id="select7">

</select>
</td>
<td nowrap="nowrap">
客户来源：
</td>
<td nowrap="nowrap">
<select name="customerSource" id="select7">

</select>
</td>
</tr>
<tr>
<td nowrap="nowrap">
行业类别：
</td>
<td colspan="3" nowrap="nowrap">
<select name="IndustryType" id="select8">

</select>
</td>
</tr>
<tr>
<td nowrap="nowrap">
省份/地区：
</td>
<td nowrap="nowrap">
<select name="province" id="select9">

</select>
</td>
<td nowrap="nowrap">
城市：
</td>
<td nowrap="nowrap">
<select name="city" id="select9">

</select>
</td>
</tr>
<tr>
<td colspan="2" nowrap="nowrap">
<label>
<input type="submit" name="button" id="button" value="确定" />
</label>
</td>
<td colspan="2" nowrap="nowrap">
<input type="reset" name="button2" id="button2" value="取消" />
</td>
</tr>
</table>
</form>

[过期的豆豆糖]

麻烦把脚本单独拿出来运行一下看，本来是张图片，可不知道怎么加上去，是一个多个条件的高级查询，我这么写的，可是当我给输入条件为空时，他什么也查不出来

-----------------------8.商品销售表存储过程
--按照日期，销售单号模糊查询，汇总表或明细表，按日期顺序，按客户分组
--查询 ：销售日期 单号，客户名称，销售单价，销售数量，销售总额，商品备注
--客户编号，商品编号，商品名称，单位，规格型号，业务员
create or replace procedure proc_commoditysellInfo_find
(
info_cursor out sys_refcursor,
startdate in varchar2,
stopdate in varchar2,
datesort in varchar2 default null,--日期排序
clientgroup in varchar2 default null,--客户分组
condition in varchar2 default null,--销售单号
--
commodityname in varchar2 default null,--商品名称
commoditymodel in varchar2 default null,--商品规格
employeename in varchar2 default null,--业务员
customerName in varchar2 default null,--客户名称
customerType in varchar2 default null,--客户类型
customerLevel in varchar2 default null,--客户阶段
customerRank in varchar2 default null,--客户级别
customerSource in varchar2 default null,--客户来源
IndustryType in varchar2 default null,--行业类别
province in varchar2 default null,--省份
city in varchar2 default null--城市
)
as
protype_sql varchar2(2000);--查询所有的sql语句
condition_sql1 varchar2(500);--条件1,起始日期，到终止日期
condition_sql2 varchar2(500);--条件2，销售单号
condition_sql3 varchar2(500);--条件3，是否按日期排序
condition_sql4 varchar2(500);--条件4，是否按客户分组
condition_sql5 varchar2(500);--条件5,商品名称
condition_sql6 varchar2(500);--条件6，商品规格
condition_sql7 varchar2(500);--条件7，业务员
condition_sql8 varchar2(500);--条件8，客户名称
condition_sql9 varchar2(500);--条件9,客户类型
condition_sql10 varchar2(500);--条件10，客户阶段
condition_sql11 varchar2(500);--条件11，客户级别
condition_sql12 varchar2(500);--条件12，客户来源
condition_sql13 varchar2(500);--条件13，行业类别
condition_sql14 varchar2(500);--条件14,省份
condition_sql15 varchar2(500);--条件15，城市

all_sql varchar2(2000);--最终sql语句
begin
protype_sql := 'select csi.selldate,csi.id,ci.id,ci.customername,c.id,c.commodityname,c.commodityunit,c.commoditymodel,
cs.commPrice,cs.commSellNum,cs.totalMoney,e.employeename,c.remark,ci.customerType,ci.customerLevel,ci.customerpank,
ci.customerSource,ci.IndustryType,ci.province,ci.city,csi.amountReceivable,csi.PaidUpMoney,csi.preferentialPrice
from commoditysellInfo csi,CustomerInformation ci,commodity c,commoditysell cs,employeeinfo e
where csi.cid = ci.id and cs.commodityId= c.id and e.id = csi.empid and cs.salesSlip = csi.id';
condition_sql1:=' and csi.selldate between to_date('''||startdate||''',''yyyy-mm-dd'') and to_date('''||stopdate||''',''yyyy-mm-dd'')';
condition_sql2:=' and csi.id like ''%' ||condition|| '%''';
condition_sql3:=' order by csi.selldate desc';

--
condition_sql5:=' and c.commodityname='''||commodityname||'''';
condition_sql6:=' and c.commoditymodel='''||commoditymodel||'''';
condition_sql7:=' and e.employeename='''||employeename||'''';
condition_sql8:=' and ci.customername='''||customerName||'''';
condition_sql9:=' and ci.customerType='''||customerType||'''';
condition_sql10:=' and ci.customerLevel='''||customerLevel||'''';
condition_sql11:=' and ci.customerRank='''||customerRank||'''';
condition_sql12:=' and ci.customerSource='''||customerSource||'''';
condition_sql13:=' and ci.IndustryType='''||IndustryType||'''';
condition_sql14:=' and ci.province='''||province||'''';
condition_sql15:=' and ci.city='''||city||'''';
all_sql:=protype_sql;
if startdate is not null then
all_sql:=protype_sql||condition_sql1;
end if;
if stopdate is not null then
all_sql:=protype_sql||condition_sql1;
end if;
if datesort is not null then
all_sql:=protype_sql;
end if;
if condition is not null then
all_sql:= all_sql||condition_sql2;
end if;

if commodityname is not null then
all_sql:=all_sql||condition_sql5;
end if;
if commoditymodel is not null then
all_sql:=all_sql||condition_sql6;
end if;
if employeename is not null then
all_sql:=all_sql||condition_sql7;
end if;
if customerName is not null then
all_sql:=all_sql||condition_sql8;
end if;
if customerType is not null then
all_sql:=all_sql||condition_sql9;
end if;
if customerLevel is not null then
all_sql:=all_sql||condition_sql10;
end if;
if customerRank is not null then
all_sql:=all_sql||condition_sql11;
end if;
if customerSource is not null then
all_sql:=all_sql||condition_sql12;
end if;
if IndustryType is not null then
all_sql:=all_sql||condition_sql13;
end if;
if province is not null then
all_sql:=all_sql||condition_sql14;
end if;
if city is not null then
all_sql:=all_sql||condition_sql15;
end if;

open info_cursor for all_sql||condition_sql1;
end;