DBMS_OUTPUT.PUTLINE( 'MTG Error');
-- MTG Error begin
-- The parser does not accept nested expressions
-- in the when clause. Once on Oracle this comment
-- needs to be taken out and the statement manually
-- written in PL/SQL.
-- NOTE the print 'MTG Error' comment block above
-- has to be removed as well
/*
update #temp1 set Deviation =
case when (abs(MaxTiming - Timing) -
abs(MinTiming - Timing)) >=0
then abs(MaxTiming - Timing) / Timing
else abs(MinTiming - Timing) / Timing
end
from #temp1 where Timing !=0
*/
-- MTG Error end
|
update TT_TEMP1_7
set Deviation =
case when
(abs(MaxTiming - Timing) -
abs(MinTiming - Timing)) >=0
then abs(MaxTiming -Timing) / Timing
else abs(MinTiming - Timing) / Timing
end
from TT_TEMP1_7 where Timing !=0
|
Bookmark
