Re: Huge difference between sqlplus and sqldeveloper - sorting in memory vs disk
- From: Greg Rahn <greg@xxxxxxxxxxxxxxxxxx>
- To: Denis <denis.sun@xxxxxxxxx>
- Date: Tue, 15 Nov 2011 07:14:51 -0800
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
