您好,登錄后才能下訂單哦!
一、通過(guò)pls塊來(lái)調(diào)用存儲(chǔ)過(guò)程;
declare
p_dzno varchar2(50);
p_vchtype VARCHAR2(50);
p_productclass VARCHAR2(50);
p_dptcode VARCHAR2(50);
begin
p_vchtype:='MP';
p_productclass:='03';
p_dptcode:='206';
PRODDATA.product_dz_proc.pd_getdzno(p_dzno,p_vchtype,p_productclass,p_dptcode);
DBMS_OUTPUT.put_line(p_dzno);
end;
二、oracle 匿名塊執(zhí)行sql
declare
CURSOR flag_cur IS select lp.product_code from lxg_product lp;
productInfo flag_cur%ROWTYPE;
flag char(1);
begin
for productInfo in flag_cur loop
select decode(
(select count(g.product_code)
from ahs_policy_product g
where g.product_code=productInfo.product_code
and g.updated_date > date '2015-07-01'
and g.created_by not in ('BIS', 'PTP', 'pacard', 'admin')
and g.created_by not in (select t.um_code from t_ptp_agent_account_info t)
and rownum = 1),0,'N','Y') into flag from dual;
DBMS_OUTPUT.PUT_LINE(productInfo.product_code ||','|| flag);
end loop;
end;
/
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如果涉及侵權(quán)請(qǐng)聯(lián)系站長(zhǎng)郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。