declare
x number:=2;
begin
if x<=0 then
dbms_output.put_line('x的值小于等于0');
elsif x<=1 then
dbms_output.put_line('x的值小于等于1');
elsif x<=2 then
dbms_output.put_line('x的值小于等于2');
else
dbms_output.put_line('x的值大于2');
end if;
end;
/
declare
x number:=100;
y number:=200;
begin
if x<y then
dbms_output.put_line('x大于y');
else
dbms_output.put_line('x小于y');
end if;
end;
x+1 (x>0)
y= x (x=0)
x-1 (x<0)
declare
grade char(1) := '&grade';
result varchar2(10);
begin
result :=case grade
when 'A' then '优'
when 'B' then '良'
when 'C' then '中'
when 'D' then '不及格'
else '数据出错!'
end ;
dbms_output.put_line('你输入的等级为' || result);
end;