https://wiki.ispirer.com/ 2026-04-14T22:26:27+00:00 https://wiki.ispirer.com/ https://wiki.ispirer.com/lib/tpl/dokuwiki/images/favicon.ico text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/analitic-and-aggregate-functions/avg?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle AVG function to HiRDB AVG function without OVER clause HiRDB database supports AVG function without OVER clause. SQLWays leaves it as is. Oracle: n:= AVG(DISTINCT a); HiRDB: SET n= AVG(DISTINCT a); AVG function with OVER clause HiRDB hasn't equivalents for AVG function with OVER clause. SQLWays leaves it as is and adds message /* SQLWays: Could not convert 'AVG' */. text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/analitic-and-aggregate-functions/count?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle COUNT function to HiRDB COUNT function without OVER clause HiRDB database supports COUNT function without OVER clause. SQLWays leaves it as is. Oracle: select COUNT(a) from t; HiRDB: select COUNT(a) from t; COUNT function with OVER clause text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/analitic-and-aggregate-functions/dense-rank?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle DENCE_RANK function to HiRDB HiRDB hasn't equivalents for DENCE_RANK function. SQLWays leaves it as is and adds message /* SQLWays: Could not convert 'DENCE_RANK' */. Oracle: select dense_rank() over(partition by col1 order by col2) from t; text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/analitic-and-aggregate-functions/grouping?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle GROUPING function to HiRDB HiRDB hasn't equivalents for GROUPING function. SQLWays leaves it as is and adds message /* SQLWays: Could not convert 'GROUPING' */. Oracle: select grouping(col1) from t; HiRDB: select grouping(col1) from t; /* SQLWays: Could not convert 'grouping' */ text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/analitic-and-aggregate-functions/last-value?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle Last_value function to HiRDB Last_value function with range between unbounded preceding and unbounded following With order by the same colon as in last_value function HiRDB database has equivalent for last_value function with range between unbounded preceding and unbounded following with order by the same colon as in last_value function. SQLWays changes last_value function with subselect with MAX function. text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/analitic-and-aggregate-functions/lead?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle LEAD function to HiRDB HiRDB hasn't equivalents for LEAD function. SQLWays leaves it as is and adds message /* SQLWays: Could not convert 'LEAD' */. Oracle: SELECT LEAD(col1, 1) OVER (ORDER BY col1) FROM t; HiRDB: SELECT LEAD(col1, 1) OVER (ORDER BY col1) FROM t; /* SQLWays: Could not convert 'LEAD' */ text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/analitic-and-aggregate-functions/max?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle MAX function to HiRDB MAX function without over clause HiRDB database supports MAX function without over clause. SQLWays leaves it as is. Oracle: n:=max(a); HiRDB: SET n = max(a); MAX function with over clause HiRDB hasn't equivalent for MAX function with over clause. SQLWays leaves it as is and adds message /*Сould not convert 'max'*/. text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/analitic-and-aggregate-functions/min?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle MIN function to HiRDB MIN function without over clause HiRDB database supports MIN function without over clause. SQLWays leaves it as is. Oracle: n:= min([ALL | DISTINCT] a); HiRDB: SET n= min([ALL | DISTINCT] a); MIN function with over clause text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/analitic-and-aggregate-functions/ntile?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle NTILE function to HiRDB HiRDB hasn't equivalents for NTILE function. SQLWays leaves it as is and adds message /* SQLWays: Could not convert 'NTILE' */. Oracle: select ntile(5) over(order by col1) from t; HiRDB: select ntile(5) over(order by col1) from t; /* SQLWays: Could not convert 'ntile' */ text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/analitic-and-aggregate-functions/rank?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle RANK function to HiRDB HiRDB hasn't equivalents for RANK function. SQLWays leaves it as is and adds message /* SQLWays: Could not convert 'RANK' */. Oracle: select rank() over (partition by c1 order by c2) from t; HiRDB: select rank() over (partition by c1 order by c2) from t; /* SQLWays: Could not convert 'rank' */ text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/analitic-and-aggregate-functions/ratio-to-report?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle RATIO_TO_REPORT function to HiRDB HiRDB hasn't equivalents for RATIO_TO_REPORT function. SQLWays leaves it as is and adds message /* SQLWays: Could not convert 'RATIO_TO_REPORT' */. Oracle: select ratio_to_report(c3) over (partition by c1) from t; text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/analitic-and-aggregate-functions/sum?rev=1741078744&do=diff 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 text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/analitic-and-aggregate-functions/width-bucket?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle Width_bucket function to HiRDB HiRDB hasn't equivalent for Width_bucket function. SQLWays leaves it as is and adds message /*Сould not convert ' WIDTH_BUCKET'*/. Oracle: SELECT WIDTH_BUCKET(c1, 100, 5000, 10) FROM t; HiRDB: SELECT WIDTH_BUCKET(c1, 100, 5000, 10) FROM t; /* Сould not convert ' WIDTH_BUCKET' */