Ispirer Website Ispirer Capabilities - Oracle Migration Free Trial

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' */

© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.