declare
  x number := 20;
begin
  if x = 10 then
    dbms_output.put_line('x = 10');
  elsif x = 20 then
    dbms_output.put_line('x = 20');
  else
    dbms_output.put_line('no data');
  end if;
end;
posted on 2009-02-19 14:24  Oracle  阅读(310)  评论(0编辑  收藏  举报