cStr = 'select * from tbl_name where a=:a1';
if aa=bb then
cStr = cStr || ' and b=:a2'
end if;
if cc<>dd then
cStr = cStr || ' and b=:a3'
end if;

dbms_sql.parse(nNum,cStr,DBMS_SQL.native);
dbms_sql.bind_variable(nNum,':a1',a1);

if aa=bb then
dbms_sql.bind_variable(nNum,':a2',a2);
end if;
if cc<>dd then
dbms_sql.bind_variable(nNum,':a3',a3);
end if;

[@more@]

動態條件的繫結變數的解決

相關文章