1.先在数据库中创建一张表:
CREATE TABLE CLASS_INFO(
CLASS_ID NUMBER(5,0),
CLASS_NAME VARCHAR2(20),
CONSTRAINT PK_CLASS_INFO PRIMARY KEY(CLASS_ID), //添加主键约束
CONSTRAINT UQ_CLASS_NAME UNIQUE(CLASS_NAME) //添加唯一约束
)
然后插入一条测试数据:
INSER INTO CLASS_INFO(CLASS_ID,CLASS_NAME) VALUES(1,'网络工程班');
2.新建一个存储教程
CREATE OR REPLACE PROCEDUE add_classInfo(classid IN number,classname OUT varchar2) //输入输出参数可只写类型,不用写长度
AS
BEGIN
SELECT class_name INTO classname FROM class_info WHERE class_id=classid;
END;
3调用存储过程:
DECLARE
className VARCHAR2(20); //此处必须给定长度,不然报错
BEGIN
add_classInfo(1,className); //调用存储过程
DBMS_OUTPUT.PUT_LINE(className);
END;
4输出的结果则应为“网络一班”,如果没有输入,请打开输出服务:set serveroutput on;