IF v_upnum LIKE '4008%'
THEN
SELECT length(rtrim(upnumber))
INTO v_len
FROM basetab_810 b
WHERE b.upnumber like '4008%'
AND rownum = 1;
IF v_upnum LIKE '95%'
THEN
SELECT length(rtrim(upnumber))
INTO v_len
FROM basetab_810 b
WHERE b.upnumber LIKE '95%'
AND rownum = 1;
dbms_output.put_line('v_count = ' || v_count);
oracle
最新推荐文章于 2023-06-14 12:11:09 发布