oracle DBMS_OUTPUT.PUT_LINE()

oralce在执行存储过程时如果要显示DBMS_OUTPUT.PUT_LINE()的输出信息，要在开启serveroutput。在sqlplus中set serveroutput on即可。DBMS_OUTPUT.PUT_LINE()输出信息分割符为||。
CREATE OR REPLACE PROCEDURE stu_proc IS
        v_Id student.id%TYPE := 1;
        v_Counter number;
BEGIN
        select count(*) into v_Counter from student;
        IF v_Counter>0 THEN
                DBMS_OUTPUT.PUT_LINE('rows is:'||v_Counter);
                delete from student;
                DBMS_OUTPUT.PUT_LINE('all data in student table is deleted');
        END IF;
        LOOP
                insert into student (id,name,score)
                values (v_Id,'wang','80');
                v_Id := v_Id + 1;
                IF v_Id > 20 THEN
                        EXIT;
                END IF;
        END LOOP;
END;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/27181165/viewspace-1062050/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/27181165/viewspace-1062050/