Oracle SQL Indeed has CTE's :) I mentioned those together with other special use cases in previous articles on my blog.