문법
-
[PL/SQL] 기초 문법IT, 프로그래밍/Database (Oracle) 2019. 1. 16. 09:18
반복문 LOOP, WHILE, FOR 1. LOOP LOOP처리문EXIT [WHEN 조건];END LOOP; 12345678910111213141516DECLARE vs_gugu_line number := 1; vs_gugu_col number :=1;BEGIN LOOP DBMS_OUTPUT.PUT_LINE( vs_gugu_line || '단 입니다.'); vs_gugu_col := 1; LOOP DBMS_OUTPUT.PUT_LINE(vs_gugu_line || ' * ' || vs_gugu_col || ' = ' || (vs_gugu_line * vs_gugu_col)); vs_gugu_col := vs_gugu_col + 1; EXIT WHEN vs_gugu_col > 9; END LOOP; vs_g..