DataBase/Oracle SQL
[SQL] PLSQL 1~100 까지의 합
햄볶는뚱땡이
2010. 1. 18. 23:12
PLSQL
1. declare //변수선언
2. v_sum number(10) := 0 ; //초기값
3. begin
4. for i in 1 ... 100 Loop
5. v_sum := v_sum + i ;
6. end Loop;
7. dbms_output.put_line ('1~100 =' || to_char(v_sum));
8. end;
9. /
실행 SQL >SET server ouput on
1. declare //변수선언
2. v_sum number(10) := 0 ; //초기값
3. begin
4. for i in 1 ... 100 Loop
5. v_sum := v_sum + i ;
6. end Loop;
7. dbms_output.put_line ('1~100 =' || to_char(v_sum));
8. end;
9. /
실행 SQL >SET server ouput on