Wookoa
Wookoa

반복문 (1)

PL/SQL : FOR문, WHILE문, CURSOR

※ loop문의 종류 3가지 1. basic loop 2. while loop 3. for loop - 문제 039 숫자 1~1000까지 출력하는데 for loop 문으로 구현해서 출력하시오. - 답 begin for i in 1 .. 1000 loop dbms_output.put_line ( ' 출력숫자 ' || i ); end loop; end; / - 문제 040 위의 스크립트를 수정해서 구구단 5단을 출력하시오. - 답 declare v_count number(10) := 0; begin for i in 1 .. 9 loop v_count := 5 * i; dbms_output.put_line ( i || ' * ' || '5' || ' = ' || v_count ); end loop; end; ..

Personal/Big Data Course | 2015. 4. 23. 08:00

Prev 1 Next
  • 분류 전체보기 (323)
    • Database (29)
      • General (1)
      • Oracle (25)
      • MySQL (3)
    • Operating System (32)
      • Linux (21)
      • Windows (9)
      • Xenserver (2)
    • Language (30)
      • Java (12)
      • Visual Basic (3)
      • C# (3)
      • WPF (2)
      • Android Studio (10)
    • Web (11)
      • PHP (6)
      • Apache (5)
    • Office (16)
      • Excel (16)
    • Distributed (3)
      • Blockchain (0)
      • ICO (0)
      • Mining (1)
      • Cryptocurrency (2)
    • Personal (201)
      • Tip (31)
      • Travel (31)
      • Movie (40)
      • Theater (1)
      • Musical (2)
      • Restaurant (25)
      • Review (31)
      • Health (12)
      • Blog (26)
      • Big Data Course (2)
Today
232
Total
568,070
Wookoa by wookoa is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License. ccbyncnd