Oracle存储过程demo
CREATE [OR REPLACE] PROCEDURE PROC_DEMO(PARAM1 IN TYPE,PARAM2 OUT TYPE)
AS
VAR1 NUMBER;
VAR2 VARCHAR2(50);
VAR3 DATE;
BEGIN
SELECT COUNT(*) INTO 变量1 FROM 表A WHERE 列名=PARAM1;
IF (判断条件) THEN
SELECT 列名 INTO 变量2 FROM 表A WHERE 列名=PARAM1;
DBMS_OUTPUT.PUT_LINE('打印信息');
ELSIF (判断条件) THEN
DBMS_OUTPUT.PUT_LINE('打印信息');
ELSE
RAISE 异常名(NO_DATA_FOUND);
END IF;
EXCEPTION
WHEN OTHERS THEN
ROLLBACK;
END;