procedure trigger exam1) SELECT 쿼리를 프로시저로 작성 CREATE OR REPLACE PROCEDURE pEMP IS vname employees.last_name%TYPE; BEGIN SELECT last_name INTO vname FROM employees WHERE employee_id=100; DBMS_OUTPUT.PUT_LINE(vname); END; / SET SERVEROUTPUT ON; EXEC pEMP; exam2) VARIABLE X VARCHAR2(25) BEGIN :X := 'Abel'; END; / SELECT EMPLOYEE_ID,FIRST_NAME,SALARY FROM EMPLOYEES WHERE LAST_NAME = :X; EMPLOYEE_ID,FIRST_NAME , SALARY.. 더보기 이전 1 ··· 254 255 256 257 258 259 260 ··· 595 다음