Ispirer Website Ispirer Capabilities - Oracle Migration Free Trial

Oracle Log function to HiRDB

Log function

HiRDB has equivalent for Log function. When first argument in Log function = 10 then SQLWays converts it to LOG10 function in other variants SQLWays converts it to division of two LN functions.

Oracle:

SELECT LOG(10,100), LOG(2,100) FROM t; 

HiRDB:

SELECT LOG10(100), LN(100)/LN(2) FROM t;

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