RE: difference between order by and between operators
- From: "Lex de Haan" <lex.de.haan@xxxxxxxxxxxxxx>
- To: <AmihayG@xxxxxxxxx>, "'Oracle-L'" <oracle-l@xxxxxxxxxxxxx>
- Date: Sun, 8 May 2005 18:29:11 +0200
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Amihay Gonen
Sent: Sunday, May 08, 2005 17:54
To: Oracle-L (oracle-l@xxxxxxxxxxxxx)
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
- References:
- difference between order by and between operators
- From: Amihay Gonen
Other related posts:
- » difference between order by and between operators
- » RE: difference between order by and between operators
- difference between order by and between operators
- From: Amihay Gonen