1、代码如下(第一种方式:用if 语句):
set serveroutput on;
declare
sal integer:=0;
begin
select sal into sal from emp where empno = 7839;
dbms_output.put_line(sal);
if(sal <= 3000)
then dbms_output.put_line('低');
elsif(sal < 5000)
then dbms_output.put_line('中');
else
dbms_output.put_line('高');
end if;
end;
/
2、执行结果如下图:
3、代码如下(第二种方式:用case语句):
set serveroutput on;
declare
sal emp.sal%type;
result varchar(20);
begin
select sal into sal from emp where empno = 7839;
case
when sal<=3000 then result := '低';
when sal > 3000 and sal < 5000 then result :='中';
else result :='高';
end case;
dbms_output.put_line(result);
end;
/
4、执行结果如下图: