Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Linguistic indexes and 'order by' won't work...

Re: Linguistic indexes and 'order by' won't work...

From: Ariel <a_at_a.com>
Date: Mon, 29 Apr 2002 12:00:15 +0100
Message-ID: <aaj5kb$jet$1@news.tpi.pl> 





> Do you think NULL values are indexed? Hint: how to distinguish one NULL

from the other.


I don't understand properly...



NULL values are not allowed... (not null for create table)



As I early say, I got this example from manual "Setting Up an NLS
Environment" - "Collation


> > Parameters" - "Sorting Character Data".




I try to remove NLSSORT(col) IS NOT NULL  - but nothing happen.
Received on Mon Apr 29 2002 - 06:00:15 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US