https://wiki.ispirer.com/ 2026-04-14T07:42:34+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/bl_conversion/syntax/connect_by?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle CONNECT BY to HiRDB If “CONNECT BY” is specified , add warning message “Could not convert” + 'CONNECT BY'. Oracle: ・・・・[WHERE condition ] [START WITH condition] CONNECT BY condition ・・・・・ HiRDB: No Equivalent text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/bl_conversion/syntax/cross_join?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle CROSS JOIN + JOINED TABLE to HiRDB SQLWays changes cross join with joined table to sub query with joined table. Oracle: SELECT * FROM (T1 CROSS JOIN T2) 　　　　　LEFT JOIN T3 ON T3.C1=T1.C1 AND T3.C2=T2.C2; HiRDB: SELECT * FROM (SELECT * FROM T1, T2) Swt_Alias 　　　　　LEFT JOIN T3 ON T3.C1=Swt_Alias.C1 AND T3.T2=Swt_Alias.C2; text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/bl_conversion/syntax/delete?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle DELETE to HiRDB If “FROM” token was omitted , add “FROM” token. And if “@dblink_name” is specified , remove “@dblink” TOKEN. If using 'subquery' , add warning message “Could not convert ” + “ this syntax”. Oracle: text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/bl_conversion/syntax/full_outer_join?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle FULL OUTER JOIN to HiRDB FULL OUTER JOIN converted to select with UNION ALL. Oracle: CREATE TABLE ORA.TEST_UPD_SEL1 ( COL3 BINARY_DOUBLE, COL4 BINARY_DOUBLE ) ; CREATE TABLE ORA.TEST_UPD_SEL ( COL1 BINARY_DOUBLE, COL2 BINARY_DOUBLE ) ; select test_upd_sel.*, test_upd_sel1.* from test_upd_sel full outer join test_upd_sel1 on test_upd_sel.col2=test_upd_sel1.col4; select test_upd_sel.col1, test_upd_… text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/bl_conversion/syntax/inner_join?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle INNER JOIN to HiRDB SQLWays places used table first in from query with inner join, if there are tables that used and not used in where query. Oracle: FROM T1 [INNER] JOIN T2 ON T1.C1=T2.C1 WHERE T2.C2=expr1 HiRDB: FROM T2 [INNER] JOIN T1 ON T1.C1=T2.C1 WHERE T2.C2=expr1 text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/bl_conversion/syntax/insert_into?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle INSERT INTO to HiRDB If “@dblink_name” is specified , remove “@dblink_name” Also if using 'subquery' after INTO token specified , add warning message “Could not convert ” + “ this syntax”. Oracle: INSERT INTO {[ schema_name.]table_name[@dblink_name] | (subquery1) | TABLE(subquery2)} [(column_name, …)] {VALUES(value, …) |subquery }; text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/bl_conversion/syntax/intersect?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle INTERSECT to HiRDB Convert query that using “EXCEPT”. Oracle: SELECT 1 FROM tt INTERSECT SELECT 2 FROM tt; HiRDB: (SELECT 1 FROM tt) EXCEPT (SELECT 1 FROM tt EXCEPT SELECT 2 FROM tt); text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/bl_conversion/syntax/join_operator?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle Style JOIN Operator (+) to HiRDB SQLWays converts (+) to LEFT JOIN. Oracle: SELECT * FROM TO1, TI2 WHERE TO1.C1=TI2.C1(+) AND TO1.C1=expr1 AND TO1.C2=expr2 AND TI2.C1(+)=expr3 AND TI2.C2(+)=expr4; HiRDB: SELECT * FROM TO1 LEFT OUTER JOIN TI2 ON TO1.C1 = TI2.C1 AND TI2.C1=expr3 AND TI2.C2=expr4 WHERE TO1.C1 = expr1 AND TO1.C2 = expr2; text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/bl_conversion/syntax/lock?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle LOCK to HiRDB If “lockmode” is 'ROW SHARE' or 'SHARE UPDATE' or 'ROW EXCLUSIVE' , remove LOCK TABLE DML. Also if “lockmode” is 'SHARE' or 'EXCLUSIVE' , convert to below. And If “NOWAIT” is specified , replace to “NO WAIT” text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/bl_conversion/syntax/merge?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle MERGE to HiRDB 'MERGE INTO' cannot be used on HiRDB. So if using 'MERGE INTO , add warning message “Could not convert ” + “ this syntax”. Oracle: MERGE INTO TABLE ・・・ HiRDB: No Equivalent text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/bl_conversion/syntax/null?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle NULL in select list to HiRDB Convert “NULL” to “CAST(NULL AS datatype)” And add comment “This conversion has inappropriate possibility”. Oracle: SELECT NULL , col1 FROM t1; HiRDB: SELECT CAST(NULL as datatype) , col1 FROM t1; /*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/bl_conversion/syntax/right_join?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle RIGHT JOIN to HiRDB SQLWays changes select statement with right join to select statement with left join. Oracle: select * from t1 right [outer] join t2 on t1.c1 = t2.c1; HiRDB: select t1.*, t2.* from t2 left [outer] join t1 on t1.c1 = t2.c1; text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/bl_conversion/syntax/sequence_next_val?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle SEQUENCE NEXT VALUE to HiRDB SQLWays changes NEXTVAL sequence to NEXT VALUE FOR sequence. Oracle: SELECT employees_seq.nextval FROM t; HiRDB: SELECT NEXT VALUE FOR employees_seq FROM t; text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/bl_conversion/syntax/truncate_cluster?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle TRUNCATE CLUSTER to HiRDB REMOVE TRUNCATE CLUSTER DML. Oracle: TRUNCATE CLUSTER db.cluster1 [ [DROP | REUSE] STORAGE ] HiRDB: No Equivalent text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/bl_conversion/syntax/unique?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle UNIQUE to HiRDB If “SELECT UNIQUE” is specified , add warning message “Could not convert” + 'UNIQUE'. Oracle: SELECT unique col1 INTO i from tab1; HiRDB: No Equivalent text/html 2025-03-04T08:59:04+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.ispirer.com/sqlways/oracle/conversions/hirdb/bl_conversion/syntax/update?rev=1741078744&do=diff User Documentation Ispirer Capabilities - Oracle Migration Pricing Oracle UPDATE to HiRDB If “@dblink_name” is specified , remove “@dblink_name” Also if using 'subquery' after UPDATE token specified , add warning message “Could not convert ” + “ this syntax”. Oracle: UPDATE {[schema_name.]table_name[@dblink_name] | (subquery) | TABLE(subquery2)} SET {column_name = {expr | subquery3 }| (column_name[, …]) = subquery4 }[, …] [WHERE {condition | CURRENT OF cursor_name}]}];