[Oracle] Function 예제
CREATE OR REPLACE FUNCTION F_GET_DATA_ID (
I_VALLUE_1 VARCHAR2,
I_VALLUE_2 VARCHAR2
)
/*******************************************************************
PROGRAM NAME : 프로그램명
DESCRIPTION : 설명
AUTHOR : 성명
HISTORY : 날짜
*******************************************************************/
RETURN VARCHAR2
IS
V_DATA_ID VARCHAR2(20);
BEGIN
/**
* 설명
*/
SELECT '1' DATA_1
INTO V_DATA_ID
FROM DUAL
;
RETURN V_DATA_ID;
EXCEPTION
WHEN NO_DATA_FOUND THEN
RETURN '';
END;https://hermeslog.tistory.com/293
[Oracle] PL/SQL 예제
DECLARE V_END_DATE VARCHAR2(8) := ''; V_LOANDATE VARCHAR2(8) := ''; I_END_DATE DATE; I_LOANDATE DATE; BEGIN DBMS_OUTPUT.ENABLE; FOR LOAN_LIST IN ( SELECT * FROM K_TABLE -- 테이블 WHERE ENDDATE NOT IN ('20150531') ) LOOP V_END_DATE := LOAN_LIST.ENDDATE;
hermeslog.tistory.com
https://hermeslog.tistory.com/289
[Oracle] Procedure 예제
CREATE OR REPLACE PROCEDURE USER_PROC ( V_VALUE_1 IN VARCHAR2, V_VALUE_2 IN VARCHAR2, V_DEPTNO IN EMP.DEPTNO%TYPE , O_ERRORCODE OUT VARCHAR2, O_ERRORMESG OUT VARCHAR2 ) IS /***************************************************************** Program Name :
hermeslog.tistory.com
https://hermeslog.tistory.com/291
[Oracle] PL/SQL PREDEFINED EXCEPTION - 미리정의된 예약
출처 : http://safitservice.blogspot.jp/2014/01/oracle-plsql-predefined-exception.html 오랜만에 PL/SQL을 하다 보니 예외처르 부분에 대해서 작성하다가 자꾸 책을 찾아 보게 되서 정리된 내용을 블러그에 올려 놓고
hermeslog.tistory.com