Re: Huge difference between sqlplus and sqldeveloper - sorting in memory vs disk
From: Greg Rahn <greg_at_structureddata.org>
Date: Tue, 15 Nov 2011 07:14:51 -0800
Message-ID: <CAGXkmisJpUeT97NOx8FE9V9XBebs0Wv7mc0FFwcCSSqpabiysg_at_mail.gmail.com>
This is something important to teach people who use SQL -- explicit (date) casting.
Date: Tue, 15 Nov 2011 07:14:51 -0800
Message-ID: <CAGXkmisJpUeT97NOx8FE9V9XBebs0Wv7mc0FFwcCSSqpabiysg_at_mail.gmail.com>
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_at_yahoo.com> 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-lReceived on Tue Nov 15 2011 - 09:14:51 CST