Re: Huge difference between sqlplus and sqldeveloper - sorting in memory vs disk

This is something important to teach people who use SQL -- explicit
(date) casting.

On Tue, Nov 15, 2011 at 6:14 AM, Denis <denis.sun@xxxxxxxxx> wrote:
> Thanks all. The caused is identified. The first subquery block in the WITH
> clause has a where condition:   m_when between  '14-Sep-2011' and
> '14-Nov-2011'  , where m_when is a DATE type. In SQL Plus, this condition
> produces zero row, while SQL developer is smart enongh to translate the
> string to date type, which gives serveral hunderd k number of rows.

-- 
Regards,
Greg Rahn
http://structureddata.org
--
http://www.freelists.org/webpage/oracle-l

Other related posts: