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

一、不带参存储 用如下一个存储做例子： 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; 执行如下命令

一、不带参存储

用如下一个存储做例子：

create or replace procedure testwhileloop IS
  v_count number := 0;
begin
  while v_count 

执行如下命令：
SQL> set serveroutput on;
SQL> exec testwhileloop;
 
v_count:2
v_count:4
v_count:6
v_count:8
v_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
) IS
v_count number:=i_count;
begin
  while v_count 

执行如下命令：
SQL> exec testwhileloop(1);
 
v_count:3
v_count:5
v_count:7
v_count:9
v_count:11
 
PL/SQL procedure successfully completed
 
SQL> drop procedure testwhileloop;
 
Procedure dropped
 
SQL> 


其中：
exec testwhileloop(1); 命令用于执行存储
drop procedure testwhileloop; 命令用于删除存储