SET SERVEROUTPUT ON;
DECLARE
V_EMPID EMP.EMPNO%TYPE;
V_SALARY EMP.SAL%TYPE;
BEGIN
SELECT EMPNO, SAL INTO V_EMPID, V_SALARY
FROM EMP
WHERE EMPNO = 7369;
DBMS_OUTPUT.PUT_LINE(V_EMPID|| ' == ' ||V_SALARY);
END;
/
DECLARE
V_EMPID EMP.EMPNO%TYPE;
V_SALARY EMP.SAL%TYPE;
BEGIN
SELECT EMPNO, SAL INTO V_EMPID, V_SALARY
FROM EMP
WHERE EMPNO = &EMPNO;
DBMS_OUTPUT.PUT_LINE(V_EMPID|| ' == ' ||V_SALARY);
END;
/
CREATE TABLE PL_TEST2
(NO NUMBER,
NAME VARCHAR2(10),
ADDR VARCHAR2(10));
SET VERIFY OFF -- 유효성체크 출력여부
DECLARE
V_NO NUMBER := '&NO';
V_NAME VARCHAR2(10) := '&NAME';
V_ADDR VARCHAR2(10) := '&ADDR';
BEGIN
INSERT INTO PL_TEST2
VALUES(V_NO, V_NAME, V_ADDR);
END;
/