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.


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


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

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