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