--?3?判斷語句
--?IF?比較式?THEN?BEGIN?END;?END?IF;
CREATE?OR?REPLACE?PROCEDURE?test(x?IN?NUMBER)
IS
??BEGIN
????IF?x?>?0
????THEN
??????BEGIN
????????x?:=?0?-?x;
??????END;
????END?IF;
????IF?x?=?0
????THEN
??????BEGIN
????????x?:=?1;
??????END;
????END?IF;
??END?test;[2017-03-21 15:48:19] [99999][17110] Warning: 執(zhí)行完畢, 但帶有警告[2017-03-21 15:48:19] completed in 8ms
oracle存儲(chǔ)過程,求指導(dǎo)
Mr丶zcy
2017-03-21 15:54:24
