oracle中建存储过程的具体实现实例(供初学者使用)

------创建表 
create table t_user
 (
 id number(4) primary key,
 uname varchar2(20),
 age number(3)
 );


((注意下面的语句结束后须加/才能执行)
-----添加的存储过程
 create or replace procedure tu_save
 (
 id in number,
 uname in varchar,
 age in number
 )
 as
 begin
 insert into t_user(id,uname,age) values(id,uname,age);
 end tu_save;

-----删除的存储过程
 create or replace procedure tu_del
 (
 b_id in number
 )
 as
 begin
 delete from t_user where id = b_id;

 end tu_del;

-----修改的存储过程
 create or replace procedure tu_update
 (
 b_id in number,
 b_uname varchar,
 b_age number
 )
 as
 begin
 update t_user set uname = b_uname,age = b_age where id = b_id;
 end tu_update;

-----查询一条数据的存储过程
create or replace procedure tu_query
(
b_id in number,
b_uname out varchar,
b_age out number
)
as
begin
select uname,age into b_uname,b_age from t_user where id = b_id;
end tu_query;

-----查询所有的存储过程(查询多个数据,步骤1，3,查询一条数据，步骤1，2)
1.先创建程序包
 create or replace package tu_queryAll as
 type aa_all is ref cursor;