摘要： 1.declare x number := 60; begin case x when 10 then dbms_output.put_line('x=10'); when 20 then dbms_output.put_line('x=20'); when 30 then dbms_output.put_line('x=30')... 阅读全文

摘要： 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; 阅读全文