Ispirer Website Ispirer Capabilities - Oracle Migration Free Trial

Oracle Least function to HiRDB

Least function

HiRDB database supports Least function. SQLWays changes Least function with arguments count more than 3 to Least function with 3 arguments, which contains Least functions.

Oracle:

SELECT LEAST ('HARRY', 'HARRIOT', 'HAROLD'), LEAST ('HARRY', 'HARRIOT', 'HAROLD', 'HOHO') FROM t;  

HiRDB:

SELECT LEAST('HARRY','HARRIOT','HAROLD'), LEAST('HARRY','HARRIOT', LEAST('HAROLD','HOHO')) FROM t ;

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