Database/PLSQL
008 - [Oracle PL/SQL] Basic Loop
unsungIT
2024. 2. 8. 09:18
<샘플코드에서 사용한 데이터는 HR 스키마이고, 오라클 설치시 생성할 수 있는 기본 스키마 입니다>
#basic loop
#write a basic loop to print 'welcome' 3 times
declare
v_counter number:=0;
begin
loop
v_counter:=v_counter+1;
dbms_output.put_line('welcome ' ||v_counter);
exit when v_counter>=3;
end loop;
end;
--------------------------------------
#another method
declare
v_counter number:=0;
begin
loop
v_counter:=v_counter+1;
dbms_output.put_line('welcome ' ||v_counter);
if v_counter>=3 then
exit;
end if;
end loop;
end;
# print the employees first name for employee 100,101,102
# using basic loop
declare
v_empno number:=100;
v_first_name employees.first_name%type ;
begin
loop
exit when v_empno>102;
select first_name into v_first_name
from employees
where employee_id = v_empno;
dbms_output.put_line(v_empno ||' '|| v_first_name);
v_empno:=v_empno+1;
end loop;
end;