Re: strange proble with to_date function in select query
Date: Mon, 27 Jul 2009 09:51:00 +0200
> What you want is the inner query to *stay*nested. Although I don't like
> hints, the NO_UNNEST hint is a possibility; another solution is adding
> and rownum > 0
The rownum > 0 did the job.
> inside the subquery, which should have the same effect but may be less
> explicit for people who will maintain the query.
With a bit of comment it should be fine.
Thank you for the suggestion.