oracle 删除存储及调用存储的命令

来源：互联网发布：如来神掌裹裹抢单软件编辑：程序博客网时间：2024/05/16 01:43

一、不带参存储

用如下一个存储做例子：

create or replace procedure testwhileloop IS  v_count number := 0;begin  while v_count < 10 loop    v_count := v_count + 2;    dbms_output.put_line('v_count:' || v_count);  end loop;end testwhileloop;

执行如下命令：

SQL> set serveroutput on;SQL> exec testwhileloop; v_count:2v_count:4v_count:6v_count:8v_count:10 PL/SQL procedure successfully completed SQL> drop procedure testwhileloop; Procedure dropped SQL>

其中：

exec testwhileloop; 命令用于执行存储

drop procedure testwhileloop; 命令用于删除存储

二、带参存储

create or replace procedure testwhileloop(i_count number) ISv_count number:=i_count;begin  while v_count < 10 loop    v_count := v_count + 2;    dbms_output.put_line('v_count:' || v_count);  end loop;end testwhileloop;

执行如下命令：

SQL> exec testwhileloop(1); v_count:3v_count:5v_count:7v_count:9v_count:11 PL/SQL procedure successfully completed SQL> drop procedure testwhileloop; Procedure dropped SQL>

其中：

exec testwhileloop(1); 命令用于执行存储

drop procedure testwhileloop; 命令用于删除存储

20 0