1 创建用户信息表
create table user_info(
id varchar2(4),
name varchar2(20),
pwd varchar2(20),
address varchar2(30)
);
2 sql 语句创建一个存储过程 AddNewUser
CREATE OR REPLACE PROCEDURE AddNewUser
(
n_id user_info.id%TYPE,
n_name user_info.name%TYPE,
n_pwd user_info.pwd%TYPE,
n_address user_info.address%TYPE
)
AS
BEGIN
--向表中插入数据
INSERT INTO user_info(id,name,pwd,address)
VALUES(n_id,n_name,n_pwd,n_address);
END AddNewUser;
/
3 存储过程的调用
方式一
declare
v_id user_info.id%TYPE := 'u003';
v_name user_info.name%TYPE:='HAPPYNESS';
v_pwd user_info.pwd%TYPE :='history';
v_add user_info.address%TYPE:='HEAVEN';
BEGIN
AddNewUser(v_id,v_name,v_pwd,v_add);
DBMS_OUTPUT.put_line('用户'||v_name||'已经成功插入');
end;
/
方式二
在SQL/PLUS 中
set serveroutput on;
call AddNewUser('u004','Beautiful','NOW','BJ');