https://wiki.ispirer.com/ 2026-04-15T02:16:49+00:00 https://wiki.ispirer.com/ https://wiki.ispirer.com/lib/tpl/dokuwiki/images/favicon.ico text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/string-functions/ascii?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle ASCII function to HiRDB HiRDB database supports ASCII function. SQLWays leaves it as is. Oracle: n:=ascii(a); HiRDB: SET n = ascii(a); References in Wiki Database Reference Oracle ASCII HiRDB ASCII text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/string-functions/concat?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle CONCAT function to HiRDB SQLWays changes CONCAT function to string concatination expression using ||. Oracle: select CONCAT('str1', 'str2') from t; HiRDB: select 'str1' || 'str2' from t; References in Wiki Database Reference Oracle text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/string-functions/instr?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle INSTR function to HiRDB HiRDB database has equivalent for INSTR function. SQLWays change instr function to POSSTR function with the same arguments. Oracle: SELECT INSTR('CORPORATE FLOOR','OR', 3, 2) FROM t; HiRDB: SELECT POSSTR('CORPORATE FLOOR','OR',3,2) FROM t; text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/string-functions/length?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle LENGTH function to HiRDB HiRDB database supports LENGTH function. SQLWays leaves it as is. Oracle: n := LENGTH(col1); HiRDB: SET n = LENGTH(col1); text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/string-functions/lengthb?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle Lengthb function to HiRDB Lengthb function HiRDB hasn't equivalent for Lengthb function. SQLWays leaves it as is and adds message /* This conversion has inappropriate possibility*/. Oracle: select lengthb(col1) from t; HiRDB: select length(col1) from t; /*This conversion has inappropriate possibility*/ text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/string-functions/lengthc?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle Lengthc function to HiRDB HiRDB database supports Lengthc function. SQLWays leaves it as is. Oracle: select lengthc(col1) from t; HiRDB: select length(col1) from t; text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/string-functions/lower?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle LOWER function to HiRDB HiRDB database supports LOWER function. SQLWays leaves it as is. Oracle: select lower(col1) from t; HiRDB: select lower(col1) from t; text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/string-functions/lpad?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle LPAD function to HiRDB HiRDB hasn't equivalents for LPAD function. SQLWays leaves it as is and adds message /* SQLWays: Could not convert 'LPAD' */. Oracle: select lpad('abc',1) from t; HiRDB: select lpad('abc', 1) from t; /* SQLWays: Could not convert 'lpad' */ text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/string-functions/ltrim?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle LTRIM function to HiRDB HiRDB database supports LTRIM function. SQLWays leaves it as is. Oracle: select ltrim(col1) from t; HiRDB: select ltrim(col1) from t; text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/string-functions/nchr?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle NCHR function to HiRDB HiRDB hasn't equivalents for NCHR function. SQLWays leaves it as is and adds message /* SQLWays: Could not convert 'NCHR' */. Oracle: select nchr(122) from t; HiRDB: select nchr(122) from t; /* SQLWays: Could not convert 'nchr' */ text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/string-functions/replace?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing 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; text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/string-functions/rpad?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle RPAD function to HiRDB HiRDB hasn't equivalent for RPAD function. SQLWays leaves it as is and adds message /* Сould not convert 'RPAD' */. Oracle: SELECT RPAD(' ', с1, '*') FROM t; HiRDB: select RPAD(' ', с1, '*') from t; /* Сould not convert 'RPAD' */ text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/string-functions/rtrim?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle RTRIM function to HiRDB HiRDB database supports RTRIM function. SQLWays leaves it as is. Oracle: select RTRIM(col1) from t; HiRDB: select RTRIM(col1) from t; text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/string-functions/substr?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle SUBSTR function to HiRDB HiRDB database supports SUBSTR function. SQLWays leaves it as is. Oracle: select substr(a,1,2) from t; HiRDB: select substr(a,1,2) from t; text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/string-functions/substrb?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle Substrb function to HiRDB HiRDB hasn't equivalent for Substrb function. SQLWays leaves it as is and adds message /*This conversion has inappropriate possibility*/. Oracle: SELECT SUBSTRB('ABCDEFG',3,4), SUBSTRB('ABCDEFG',3) FROM t; HiRDB: text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/string-functions/translate?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle Translate…Using function to HiRDB Translate…Using HiRDB hasn't equivalent for Translate…Using function. SQLWays leaves it as is and adds message /*Сould not convert ' TRANSLATE '*/. Oracle: SELECT TRANSLATE(nchar_col USING CHAR_CS) FROM t; text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/functions/string-functions/upper?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle UPPER function to HiRDB HiRDB database supports UPPER function. SQLWays leaves it as is. Oracle: select UPPER(a) from t; HiRDB: select UPPER(a) from t;