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;
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博客 ” ，链接：https://blog.itpub.net/27181165/viewspace-1062050/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
oracle新建用户
请登录后发表评论
登录
全部评论
