oracle怎么删除存储,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 < 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: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 < 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: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; 命令用于删除存储 本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉 本文系统来源：php中文网