Oracel_PL/SQL 流程控制

1.查询150号 员工工资，如果大于等于10000，则打印salary》=10000，若在5000-10000之间，则打印5000<=salary<=10000,

declaer

v_sal employees.salary%type;

begin

select salary into v_sal from employees where employees_id=150;

  if v_sal >=10000 then  dbms_output.put_line('salary>=10000');

elsif val >=5000 then dbms_output.put_line('5000<=salary<=10000');

else  dbms_output.put_line('salary<=5000');

end if;

end;

2.使用循环打印1到100

declaer

v_i number(5):=1;

begin

loop

dbms_output.put_line(v_i);

v_i:=v_i+1;

exit when v_i>100;

end loop;

end;

或:

while v_i<=100 loop

dbms_output.put_line(v_i);

v_i:=v_i+1;

end loop;

或：

begin

for c in 1..100 loop

dbms_output.put_line(v_i);

end loop;

end;