摘要： 函数定义：CREATE OR REPLACE FUNCTION fun_sum(base IN NUMBER)RETURN VARCHAR2IS BEGINIF base>0 THENRETURN '1';ELSIF base<0 THENRETURN '0';ELSE RETURN '-1';END IF;END ;函数调用：SQL> var d varchar2;SQL> exec :d := fun_sum(2);PL/SQL procedure successfully completedd---------1 阅读全文

摘要： 存储过程：create or replace procedure pro_my(city out varchar,names out varchar,temp varchar)ASbegin city:=temp; names:='world';end;调用：DECLARE v_city VARCHAR(99); v_name VARCHAR(99);BEGIN pro_my(v_city, v_name, 'test'); dbms_output.put_line(v_city || ' ' || v_name);END;注意声明的时候需要带上 阅读全文