Oracle PL/SQL 笔记 Basic Info

Oracle Function

Function 需要有回传值

SELECT GET_EMPLOYEENAME('A12345') FROM DUAL;

CREATE OR REPLACE FUNCTION GET_EMPLOYEENAME(IN_EMPLOYEEID IN VACHAR2)RETURN VACHAR2IS    V_NAME VACHAR2(20);BEGIN    SELECT EMPLOYEES.NAME     INTO V_NAME    FROM EMPLOYEES     WHERE EMPLOYEES.ID = IN_EMPLOYEEID;    RETURN V_NAMEEND GET_EMPLOYEENAME;

Oracle Procedure

Procedure 无回传值

EXECUTE DELETE_EMPLOYEENAME('A12345');

CREATE OR REPLACE PROCEDURE DELETE_EMPLOYEENAME (    IN_EMPLOYEEID IN VACHAR2) ISBEGIN    DELETE FROM EMPLOYEES    WHERE EMPLOYEES.ID = IN_EMPLOYEEID;    COMMIT;END;

Oracle Package （集合 Function、Procedure）分为 Spec、Body