5 ms·

I didn't think Oracle SQL server has CTEs, but maybe that's changed. Postgres CTEs are amazing, though. Surprisingly efficient for our particular usage case (t

by gtaylor 12y ago

I didn't think Oracle SQL server has CTEs, but maybe that's changed. Postgres CTEs are amazing, though. Surprisingly efficient for our particular usage case (threaded discussions that don't ever get too deep).

thebillkidy 12y ago
Oracle SQL Indeed has CTE's :) I mentioned those together with other special use cases in previous articles on my blog.
dragonwriter 12y ago
Oracle has recursive CTEs since, I think, 11gR2, and non-recursive CTEs since 9.2.