I do believe that whatever an analytic function does can be done by
native SQL, with join and sub-queries. However, the same when done by
analytic function is never slower, if not faster, when compared to
native SQL.
Yes offcourse, I am not considering the amount of time that spent in
coding the native SQLs, testing, debugging and tuning them. That is just
an additional work.