SQL9 Day 58. [PL/SQL] 익명 블록, 제어문 익명 블록 사용 방법 SET SERVEROUTPUT ON; SET TIMING ON; DECLARE vi_num INTEGER; BEGIN vi_num := 100.5; DBMS_OUTPUT.PUT_LINE(vi_num); END; / DECLARE A INTEGER := 2**2*3**2; BEGIN DBMS_OUTPUT.PUT_LINE('A = '||A); END; / DECLARE V_NAME STUDENT.NAME%TYPE; V_DEPTNO STUDENT.DEPTNO%TYPE; BEGIN SELECT NAME, DEPTNO INTO V_NAME, V_DEPTNO FROM STUDENT WHERE STUDNO = 10101; DBMS_OUTPUT.PUT_LINE(V_NAME || '-' || V_D.. 2022. 3. 29. 이전 1 2 3 다음