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

From: Greg Rahn <>
Date: Tue, 15 Nov 2011 07:14:51 -0800
Message-ID: <>

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

On Tue, Nov 15, 2011 at 6:14 AM, Denis <> 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.

Greg Rahn
Received on Tue Nov 15 2011 - 09:14:51 CST

Original text of this message