헤르메스 LIFE

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 : 프로시져명 Description : 설명 Author : 성명 History : 날짜****************************************************************..

Oracle Array 샘플 #1 DECLARE type employeeNames IS VARRAY(6) OF VARCHAR2(10); type salary IS VARRAY(6) OF INTEGER; names employeeNames; salaries salary; total integer; BEGIN names := employeeNames('Mayur', 'Ekta', 'Pari', 'Yashika', 'Payal'); salaries:= salary(9845, 9007, 7813, 8754, 9022); total := names.count; dbms_output.put_line('Total '|| total || ' Employees'); FOR i in 1 .. total LOOP dbms_..

FOR..LOOP DECLARE BEGIN DBMS_OUTPUT.ENABLE; FOR EMP_LIST IN ( SELECT * FROM EMPLOYEES WHERE TO_CHAR(HIRE_DATE, 'YYYYMMDD') BETWEEN '20000101' AND '20101231' AND LAST_NAME = 'King' ) LOOP DBMS_OUTPUT.PUT_LINE('EMPLOYEE_ID :: ' || EMP_LIST.EMPLOYEE_ID); DBMS_OUTPUT.PUT_LINE('FIRST_NAME :: ' || EMP_LIST.FIRST_NAME); DBMS_OUTPUT.PUT_LINE('LAST_NAME :: ' || EMP_LIST.LAST_NAME); DBMS_OUTPUT.PUT_LINE('..

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 ; RETUR..