RE: difference between order by and between operators

From: Lex de Haan <lex.de.haan_at_naturaljoin.nl>
Date: Sun, 8 May 2005 18:29:11 +0200
Message-Id: <20050508162909.B99D18011C70@smtp-out0.tiscali.nl>

yes, there is a difference between sorts and comparisons. in 10g, for comparison behavior you can set the NLS_COMP parameter to ANSI. the default is BINARY.
kind regards,

Lex.  

---

Visit my website at http://www.naturaljoin.nl

---

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Amihay Gonen
Sent: Sunday, May 08, 2005 17:54
To: Oracle-L (oracle-l_at_freelists.org)
Subject: difference between order by and between operators

Hi ,
we have notice differences between the operator of order by and between.  

It seems that nls_sort effect only the order by sort operator , but not the between.

--

http://www.freelists.org/webpage/oracle-l Received on Sun May 08 2005 - 12:33:41 CDT