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

From: Denis <denis.sun_at_yahoo.com>
Date: Tue, 15 Nov 2011 06:59:43 -0800 (PST)
Message-ID: <1321369183.83817.YahooMailNeo_at_web161802.mail.bf1.yahoo.com>

SQL Plus does not throw error in the case below:
 

SQL> alter session set nls_date_format='yyyy-mm-dd HH24:mi:ss'; Session altered.
SQL> select count(*) from  dba_objects where created between '1-Nov-2011' and '14-Nov-2011';
  COUNT(*)

---

         0

SQL> alter session set nls_date_format='dd-Mon-yyyy HH24:mi:ss'; Session altered.
SQL> select count(*) from  dba_objects where created between '1-Nov-2011' and '14-Nov-2011';
  COUNT(*)

---

      2987
 

- Denis

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Nov 15 2011 - 08:59:43 CST