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

From: Denis <denis.sun@xxxxxxxxx>
To: "Taylor, Chris David" <ChrisDavid.Taylor@xxxxxxxxxxxxxxx>
Date: Tue, 15 Nov 2011 06:14:31 -0800 (PST)

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. 
 
- Denis
--
http://www.freelists.org/webpage/oracle-l

Follow-Ups:

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

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

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

References:
- Huge difference between sqlplus and sqldeveloper - sorting in memory vs disk
  - From: Denis
- Re: Huge difference between sqlplus and sqldeveloper - sorting in memory vs disk
  - From: Denis
- RE: Huge difference between sqlplus and sqldeveloper - sorting in memory vs disk
  - From: Taylor, Chris David

Other related posts:

» Huge difference between sqlplus and sqldeveloper - sorting in memory vs disk - Denis
» Re: Huge difference between sqlplus and sqldeveloper - sorting in memory vs disk - Denis
» RE: Huge difference between sqlplus and sqldeveloper - sorting in memory vs disk - Taylor, Chris David
» Re: Huge difference between sqlplus and sqldeveloper - sorting in memory vs disk - Greg Rahn
» Re: Huge difference between sqlplus and sqldeveloper - sorting in memory vs disk - Denis
» Re: Huge difference between sqlplus and sqldeveloper - sorting in memory vs disk - Sidney Chen
» RE: Huge difference between sqlplus and sqldeveloper - sorting in memory vs disk - Taylor, Chris David
» Re: Huge difference between sqlplus and sqldeveloper - sorting in memory vs disk - Denis
» Re: Huge difference between sqlplus and sqldeveloper - sorting in memory vs disk - Rich Jesse
» Re: Huge difference between sqlplus and sqldeveloper - sorting in memory vs disk - Norman Dunbar
» Re: Huge difference between sqlplus and sqldeveloper - sorting in memory vs disk - Denis
» Re: Huge difference between sqlplus and sqldeveloper - sorting in memory vs disk - Greg Rahn
» Re: Huge difference between sqlplus and sqldeveloper - sorting in memory vs disk - Sidney Chen
» Re: Huge difference between sqlplus and sqldeveloper - sorting in memory vs disk - Denis
» Re: Huge difference between sqlplus and sqldeveloper - sorting in memory vs disk - Norman Dunbar
» Re: Huge difference between sqlplus and sqldeveloper - sorting in memory vs disk - Norman Dunbar