Re: Need Help on changing ORDER BY sorting technique

aru wrote:
> Hi,
> I have requirement to sort the data something similar to Dictionary.
> For example: I have to get the words those have starting character :
> spaces, hypen, dashes (any number), $, #, /,\ etc...
>
> I want to sort the data in above order. Please help me how to approach
> in Oracle database.
>
>
> Thanks a lot..
>
> Arumugam

Go to Morgan's Library at www.psoug.org
Click on ORDER BY
Scroll down to "Non-Default Ordering"

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org