Article Harry Tong · Jun 6 2m read Converting Oracle Hierarchical Queries to InterSystems IRIS: Generating Date Ranges If you're migrating from Oracle to InterSystems IRIS—like many of my customers—you may run into Oracle-specific SQL patterns that need translation. Take this example: SELECT (TO_DATE('2023-05-12','YYYY-MM-DD') - LEVEL + 1) AS gap_date FROM dual CONNECT BY LEVEL <= (TO_DATE('2023-05-12','YYYY-MM-DD') - TO_DATE('2023-05-02','YYYY-MM-DD') + 1); In Oracle: #Databases #JDBC #Management Portal #ObjectScript #ODBC #Python #SQL #Caché #InterSystems IRIS 2 1 0 63