CREATE PROCEDURE ConditionReserve (isbn varchar2(20),pub_code varchar2(4),author varchar2(30),name varchar2(40),ydrq1 date,ydrq2 date) AS misbn varchar2(20):='%'||rtrim(isbn)||'%'; mauthor varchar2(30):='%'||rtrim(author)||'%'; mname varchar2(40):='%'||rtrim(@name)||'%'; curosr t_sor is SELECT a.*,b.pub_name,c.shushang_name,d.zdlx_name,e.ztxs_name from lib_cb a,publisher b,shushang c,zdlx d,ztxs e where decode(a.isbn,null,a.isbn,misbn) and decode(a.pub_code,null,a.pub_code,pub_code) and decode(a.name,null,a.name,mname) and decode(thor,null,a.zyzr,mauthor) and ydrq>=ydrq1 and ydrq<=ydrq2 and cgrq is null and a.pub_code=b.pub_code and a.zdlx_code=d.zdlx_code and a.ztxs_code=e.ztxs_code and a.shushang_code=c.shushang_code但像like case语句不知怎样实现
搜索一下论坛中“记录集”的贴子,已经讨论了n遍了。
misbn varchar2(20):='%'||rtrim(isbn)||'%';
mauthor varchar2(30):='%'||rtrim(author)||'%';
mname varchar2(40):='%'||rtrim(@name)||'%';
curosr t_sor is
SELECT a.*,b.pub_name,c.shushang_name,d.zdlx_name,e.ztxs_name
from lib_cb a,publisher b,shushang c,zdlx d,ztxs e
where decode(a.isbn,null,a.isbn,misbn) and decode(a.pub_code,null,a.pub_code,pub_code) and decode(a.name,null,a.name,mname) and decode(thor,null,a.zyzr,mauthor) and ydrq>=ydrq1 and ydrq<=ydrq2 and cgrq is null and a.pub_code=b.pub_code and a.zdlx_code=d.zdlx_code and a.ztxs_code=e.ztxs_code and a.shushang_code=c.shushang_code但像like case语句不知怎样实现