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/,如需转载,请注明出处,否则将追究法律责任。