Ispirer Website Ispirer Capabilities - Oracle Migration Free Trial

Oracle Replace function to HiRDB

HiRDB database doesn't supports Replace function but has its equivalent. SQLWays changes it to replace_long function.

Oracle:

select replace('JACK and JUE','J','BL') from t; 

HiRDB:

select replace_long('JACK and JUE','J','BL') from t; 

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