I'm sorry, but I didnt understand by what you mean by get optimized by oracle. CAn I just run this query as shown above in oracle? I would have thought not.
I just want to run this query on sql*plus.

thanks
pst