17,086
社区成员
发帖
与我相关
我的任务
分享
CREATE OR REPLACE PROCEDURE SP_XXX(T_ID IN NUMBER , T_NAME OUT VARCHAR2)
IS
BEGIN
SELECT NAME INTO T_NAME FROM STUDENTS WHERE ID=T_ID;
END;
调用存储过程,打印name
DECLARE
ID STUDENTS.ID%TYPE:=1;
NAME STUDENTS.NAME%TYPE;--定义一个和students中name列类型相同的变量
BEGIN
SP_XXX(ID,NAME);
DBMS_OUTPUT.put_line(NAME);--打印name信息
END;
函数就不在演示了。。。CREATE OR REPLACE FUNCTION GETName(p_id in number) RETURN varchar2 IS
v_name varchar2(100);
BEGIN
select max(name) INTO V_NAME from A where id=p_id;
RETURN V_NAME;
END;