/* Formatted on 2013/06/13 09:19 (Formatter Plus v4.8.8) */
DECLARE
num NUMBER;
BEGIN
SELECT COUNT (*)
INTO num
FROM glb_rpt_uph
WHERE start_time = TO_DATE ('2013-6-13 15:30:00', 'yyyy-MM-dd hh24:mi:ss');
IF num <> 0
THEN
UPDATE glb_rpt_uph
SET model = 'AK73-BTE-EA1',
shift = 'd',
end_time =
TO_DATE ('2013-6-13 16:30:00', 'yyyy-MM-dd hh24:mi:ss'),
input = 0,
output = 0,
fpy = 1,
uph = 107,
upph = 4
WHERE start_time =
TO_DATE ('2013-6-13 15:30:00', 'yyyy-MM-dd hh24:mi:ss');
ELSE
INSERT INTO glb_rpt_uph
VALUES ('AK73-BTE-EA1', 'd',
TO_DATE ('2013-6-13 15:30:00', 'yyyy-MM-dd hh24:mi:ss'),
TO_DATE ('2013-6-13 16:30:00', 'yyyy-MM-dd hh24:mi:ss'),
0, 0, 1, 107, 4);
END IF;
END;
如題,雖然可以實現功能,但是
點擊“救護車”圖標就是沒有顯示查詢的路徑
怕以後會影響功能
oracle?ora-00905
------解决方案--------------------
你是哪国人??
要找问题:
1.先把每个分句执行一遍;;
2.建议,大包一下,做个执行体.
------解决方案--------------------
直接用merge into 语句不就可以了,还弄这么复杂。