Hi, > Can H2, using Oracle compatibility mode, execute CONNECT BY PRIOR > hierarchical queries?
No, I'm afraid this isn't supported. > - will this be supported in future releases? I'm not sure. My plan is to improve support for recursive queries, as this is the SQL standard as far as I understand: http://h2database.com/html/advanced.html#recursive_queries - while the Oracle syntax is proprietary I believe (please tell me if I'm wrong). > - is there any way to work around this currently? Maybe partially with recursive queries. Regards, Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
