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;