Max wrote:
>I have a question already submitted 2 months ago but never resolved.
>
>I have to place numeric characters before alphabetic characters sorting
>varchar2 fields.
>
>Example:
> Unsorted: [ AAA, bbb, 111, FFF, èèè, xxx, 666, ZZZ ]
> Sorted: [ AAA, bbb, èèè, FFF, xxx, ZZZ, 111, 666 ]
> I need: [ 111, 666, AAA, bbb, èèè, FFF, xxx, ZZZ ]
>
>I use oracle parameters:
> NLS_LANGUAGE = ITALIAN
> NLS_SORT = WEST_EUROPEAN
>
>I can't use NLS_SORT = BINARY because I lose the "intelligent" sort that
>work case insensitive and with special characters.
>
>Example:
> NLS_SORT = WEST_EUROPEAN ====> ( A, a, à, C, c, E, e, è, X, x, 1, 2,
>3 )
> NLS_SORT = BINARY ============> ( 1, 2, 3, A, C, E, X, a, c, e, x, à,
>è )
> I need =========================> ( 1, 2, 3, A, a, à, C, c, E, e, è, X,
>x )
>
>Thanks a lot!
>
>
>
>
Create your own operator and use it in the ORDER BY clause.
--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Tue Sep 02 2003 - 11:44:32 CDT
