DECLARE v_syscd char(3); v_sysnm varchar2(30); BEGIN SELECT syscd, sysnm INTO v_syscd, v_sysnm FROM sysmta WHERE syscd = '001'; dbms_output.put_line('syscd=' || v_syscd || ', sysnm=' || v_sysnm); END;
输出结果:syscd=001, sysnm=姅幃夛幮嶰榓
DECLARE v_syscd char(3); v_sysnm varchar2(30); BEGIN SELECT syscd, sysnm INTO v_syscd, v_sysnm FROM sysmta WHERE syscd = '001'; dbms_output.put_line('syscd=' || v_syscd || ', sysnm=' || v_sysnm); END;
输出结果:syscd=001, sysnm=姅幃夛幮嶰榓