Does anyone know how to change collating sequence in Oracle, either at the database level or for a specific query?
We have a mainframe (ebcdic) app that is converted to NT (acsii) and some special characteres (e.g. period(.) dash (-) etc.) not sorting properly.
If using functions, please show example,
Thanks
John Baylis
Database Administrator
Canadian Forest Products Ltd.
Vancouver B.C. Canada
> (604) 697-6476 (Office)
> (604) 313-6054 (Cell)
>