Re: order by question

It may depend on the nls_ parameters
 because when I created the same table and data I got the result you wanted...

I'm running Oracle 8.15, with NLS_LANG = AMERICAN and NLS_SORT = BINARY

Maybe Thomas K is listening....

"Frank Streitzig" <Frank.Streitzig_at_T-Online.de> wrote:

>Hi,
>
>i have a order by question. I have a table x with one column t char(5). The
>table contain 6 rows.
>
>#1
>1)
>#2
>2)
>#3
>3)
>
>I like sort table (select t from x order by t), but receive no order.
>I like follow sorting:
>
>#1
>#2
>#3
>1)
>2)
>3)
>
>Can anybody help me?
>
>Sorry for my language. :-)
>
>Frank Streitzig
>Germany
>

  -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------    http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Mon Dec 13 1999 - 12:24:18 CST