Re: Oracle 8i игнорирует '+' в VARCHAR2 при сортировке в SEL
От: Denis Popov Россия http://picasaweb.google.com/denislpopov
Дата: 14.02.06 17:04
Оценка: 3 (1)
Здравствуйте, Artemy.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production

SQL> alter session set nls_sort = russian;

Session altered.

SQL> select value
  2  from (select '+01732879611' value from dual union all
  3        select '07755544410' value from dual  union all
  4        select '07766666600' value from dual  union all
  5        select '07766666610' value from dual  union all
  6        select '07876910000' value from dual  union all
  7        select '+73535550100' value from dual union all
  8        select '+75551112244' value from dual union all
  9        select '+791844202' value from dual   union all
 10        select '+79995556664' value from dual union all
 11        select '80004444100' value from dual
 12       )
 13  order by value;

VALUE
------------
+01732879611
07755544410
07766666600
07766666610
07876910000
+73535550100
+75551112244
+791844202
+79995556664
80004444100

10 rows selected.

SQL> alter session set nls_sort = binary;

Session altered.

SQL> select value
  2  from (select '+01732879611' value from dual union all
  3        select '07755544410' value from dual  union all
  4        select '07766666600' value from dual  union all
  5        select '07766666610' value from dual  union all
  6        select '07876910000' value from dual  union all
  7        select '+73535550100' value from dual union all
  8        select '+75551112244' value from dual union all
  9        select '+791844202' value from dual   union all
 10        select '+79995556664' value from dual union all
 11        select '80004444100' value from dual
 12       )
 13  order by value;

VALUE
------------
+01732879611
+73535550100
+75551112244
+791844202
+79995556664
07755544410
07766666600
07766666610
07876910000
80004444100

10 rows selected.
 
Подождите ...
Wait...
Пока на собственное сообщение не было ответов, его можно удалить.