Table of Contents
Ispirer Website
Ispirer Capabilities - Oracle Migration
Free Trial
Oracle SUM function to HiRDB
SUM function without over clause
HiRDB database supports SUM function without over clause. SQLWays leaves it as is.
Oracle:
select sum([DISTINCT|ALL] a);
HiRDB:
SET n= sum([DISTINCT|ALL] a);
SUM function with over clause
HiRDB hasn't equivalent for SUM function with over clause. SQLWays leaves it as is and adds message /*Сould not convert 'sum'*/.
Oracle:
n:= sum([DISTINCT|ALL] a) over (partition by b);
HiRDB:
SET n= sum([DISTINCT|ALL] a) over (partition by b); /*Сould not convert 'sum'*/