Re: strange proble with to_date function in select query

From: Bartek <>
Date: Mon, 27 Jul 2009 09:51:00 +0200
Message-ID: <>


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


Received on Mon Jul 27 2009 - 02:51:00 CDT

Original text of this message