стандратные настройки базы nls_language = 'AMERICAN'
with t as (
select '01' idn from dual union all
select '11' idn from dual union all
select '29' idn from dual union all
select '20' idn from dual union all
select 'A0' idn from dual union all
select 'AA' idn from dual
)
select t.*,row_number() over (order by idn), max(idn) keep(dense_rank last order by idn) over()
from t order by idn
alter session set nls_language = 'RUSSIAN'
и еще раз запрос
with t as (
select '01' idn from dual union all
select '11' idn from dual union all
select '29' idn from dual union all
select '20' idn from dual union all
select 'A0' idn from dual union all
select 'AA' idn from dual
)
select t.*,row_number() over (order by idn), max(idn) keep(dense_rank last order by idn) over()
from t order by idn
в результате keep`у на изменившиеся настройки nls_language положить или это меня так старательно глючит?
проверял на 10.2.0.4 и 11.2.0.1