--查询不出数据
DECLARE
v_batchno varchar2(50);
BEGIN
v_batchno := '509702C4';
FOR sd IN (SELECT *
FROM (SELECT "F_BatchNo" AS f_batchno FROM tns_m0001) ss
WHERE ss.f_batchno = v_batchno) LOOP
dbms_output.put_line(sd.f_batchno);
END LOOP;
END;--可以查出数据,打印结果
DECLARE
v_batchno varchar2(50);
BEGIN
v_batchno := '509702C4';
FOR sd IN (SELECT *
FROM (SELECT "F_BatchNo" AS f_batchno FROM tns_m0001) ss
WHERE ss.f_batchno = '509702C4') LOOP
dbms_output.put_line(sd.f_batchno);
END LOOP;
END;
DECLARE
v_batchno varchar2(50);
BEGIN
v_batchno := '509702C4';
FOR sd IN (SELECT *
FROM (SELECT "F_BatchNo" AS f_batchno FROM tns_m0001) ss
WHERE ss.f_batchno = v_batchno) LOOP
dbms_output.put_line(sd.f_batchno);
END LOOP;
END;--可以查出数据,打印结果
DECLARE
v_batchno varchar2(50);
BEGIN
v_batchno := '509702C4';
FOR sd IN (SELECT *
FROM (SELECT "F_BatchNo" AS f_batchno FROM tns_m0001) ss
WHERE ss.f_batchno = '509702C4') LOOP
dbms_output.put_line(sd.f_batchno);
END LOOP;
END;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货