定义:
DBMS_OUTPUT.PUT_LINE (item IN VARCHAR2);
使用:
-- 必须有,不然无法显示会报错 SET SERVEROUTPUT ON DECLARE NUM INT := 0; num_max INT := 8; BEGIN dbms_output.put_line('FOR i IN 0 .. 3'); FOR i IN 0 .. 3 LOOP dbms_output.put_line('f(' || i || ') = ' || i); END LOOP; dbms_output.put_line('FOR i IN 1 .. 3'); FOR i IN 1 .. 3 LOOP dbms_output.put_line('f(' || i || ') = ' || i); END LOOP; dbms_output.put_line('FOR i IN ' || NUM || ' .. ' || num_max); FOR i IN NUM .. num_max LOOP dbms_output.put_line('f(' || i || ') = ' || i); END LOOP; END;
原创文章,作者:奋斗,如若转载,请注明出处:https://blog.ytso.com/tech/database/272286.html