Table of Contents
User Documentation
Ispirer Capabilities - Oracle Migration
Pricing
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'*/