Re: strange proble with to_date function in select query

> 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.

Regards,
Bartek

--
http://www.freelists.org/webpage/oracle-l