https://wiki.ispirer.com/ 2026-04-14T21:13:36+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/dt_conversion/bfile?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle BFILE to HiRDB Oracle BFILE type changed to its equivalent in HiRDB. Oracle: BFILE HiRDB: BINARY(2147483647) text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/dt_conversion/binary_double?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle BINARY_DOUBLE to HiRDB Oracle BINARY_DOUBLE type changed to its equivalent in HiRDB. Oracle: BINARY_DOUBLE HiRDB: FLOAT text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/dt_conversion/binary_float?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle BINARY_FLOAT to HiRDB Oracle BINARY_FLOAT type changed to its equivalent in HiRDB. Oracle: BINARY_FLOAT HiRDB: SMALLFLT text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/dt_conversion/blob?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle BLOB to HiRDB There is no need to change Oracle BLOB. Oracle: BLOB HiRDB: BLOB text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/dt_conversion/char_n?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle CHAR(n) to HiRDB Oracle CHAR(n) type changed to its equivalent in HiRDB. Oracle: CHAR(n) HiRDB: MCHAR(n) text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/dt_conversion/clob?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle CLOB to HiRDB Oracle CLOB type changed to its equivalent in HiRDB. Oracle: CLOB HiRDB: BINARY(2147483647) text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/dt_conversion/date?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle DATE to HiRDB Oracle DATE type changed to its equivalent in HiRDB. Oracle: DATE HiRDB: TIMESTAMP text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/dt_conversion/float?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle FLOAT to HiRDB Oracle FLOAT type changed to its equivalent in HiRDB. Oracle: FLOAT HiRDB: FLOAT text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/dt_conversion/interval_day_to_second?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle INTERVAL DAY TO SECOND to HiRDB Oracle INTERVAL DAY TO SECOND type changed to its equivalent in HiRDB. Oracle: INTERVAL DAY TO SECOND HiRDB: INTERVAL HOUR TO SECOND text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/dt_conversion/interval_year_to_month?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle INTERVAL YEAR TO MONTH to HiRDB Oracle INTERVAL YEAR TO MONTH type changed to its equivalent in HiRDB. Oracle: INTERVAL YEAR TO MONTH HiRDB: INTERVAL YEAR TO DAY text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/dt_conversion/long_raw?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle LONG RAW to HiRDB Oracle LONG RAW type changed to its equivalent in HiRDB. Oracle: LONG RAW HiRDB: BINARY(2147483647) text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/dt_conversion/long?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle LONG to HiRDB Oracle LONG type changed to its equivalent in HiRDB. Oracle: LONG HiRDB: BINARY(2147483647) text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/dt_conversion/nchar_n?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle NCHAR(n) to HiRDB Oracle NCHAR(n) type changed to its equivalent in HiRDB. Oracle: NCHAR(n) HiRDB: MCHAR(n×2) text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/dt_conversion/nclob?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle NCLOB to HiRDB Oracle NCLOB type changed to its equivalent in HiRDB. Oracle: NCLOB HiRDB: BINARY(2147483647) text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/dt_conversion/number_p_s?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle NUMBER(p,s) to HiRDB Oracle NUMBER(p,s) type changed to its equivalent in HiRDB. Oracle: NUMBER(p,s) HiRDB: If 's' >= 0 , convert to DEC(p,s). If 's' < 0 , convert to DEC(p+s,0). text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/dt_conversion/number_p?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle NUMBER(p) to HiRDB Oracle NUMBER(p) type changed to its equivalent in HiRDB. Oracle: NUMBER(p) HiRDB: If 'p' < 10 , convert to INT. If 'p' >= 10 , convert to DEC(p). text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/dt_conversion/number?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle NUMBER to HiRDB Oracle NUMBER type changed to its equivalent in HiRDB. Oracle: NUMBER HiRDB: FLOAT text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/dt_conversion/nvarchar2_n?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle NVARCHAR2(n) to HiRDB Oracle NVARCHAR2(n) type changed to its equivalent in HiRDB. Oracle: NVARCHAR2(n) HiRDB: MVARCHAR(n×2) text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/dt_conversion/raw_n?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle RAW(n) to HiRDB Oracle RAW(n) type changed to its equivalent in HiRDB. Oracle: RAW(n) HiRDB: BINARY(n) text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/dt_conversion/rowid?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle ROWID to HiRDB There is no equivalent of Oracle ROWID in HiRDB. Add message “/*Could not convert 'ROWID'*/”. Oracle: CREATE TABLE hanbai ( col1 ROWID, col2 FLOAT ); HiRDB: CREATE TABLE hanbai ( col1 ROWID, col2 FLOAT ); /*Could not convert 'ROWID'*/ text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/dt_conversion/timestamp_n?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle TIMESTAMP(n) to HiRDB If 'n' >= 6, convert to TIMESTAMP(6). If 'n' is odd number, 'n' + 1. Oracle: TIMESTAMP(n) [WITH [LOCAL] TIME ZONE] HiRDB: TIMESTAMP(n) text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/dt_conversion/timestamp?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle TIMESTAMP to HiRDB There is no need to chage Oracle TIMESTAMP. Oracle: TIMESTAMP HiRDB: TIMESTAMP text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/dt_conversion/varchar_n?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle VARCHAR(n) to HiRDB Oracle VARCHAR(n) type changed to its equivalent in HiRDB. Oracle: VARCHAR(n) HiRDB: MVARCHAR(n) text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/dt_conversion/varchar2_n?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle VARCHAR2(n) to HiRDB Oracle VARCHAR2(n) type changed to its equivalent in HiRDB. Oracle: VARCHAR2(n) HiRDB: MVARCHAR(n) text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/dt_conversion/varchar2?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle VARCHAR2 to HiRDB Oracle VARCHAR2 type changed to its equivalent in HiRDB. Oracle: VARCHAR2 HiRDB: MVARCHAR