Need Help on changing ORDER BY sorting technique

#1

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

#2

aru wrote:

Quote:

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@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

#3

aru wrote:

Quote:

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,

Eh? A word is that what is between spaces. Ergo: a word
cannot start with a space.

(An entry in a tuple can, though)

--
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

#4

On Dec 11, 9:30 pm, DA Morgan <damor... (AT) psoug (DOT) org> wrote:

Quote:

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 atwww.psoug.org
Click on ORDER BY
Scroll down to "Non-Default Ordering"
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damor...@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Groupwww.psoug.org

Thanks...I will look into it.

Arumugam

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Need Help on changing ORDER BY sorting technique

comp.databases.oracle.misc comp.databases.oracle.misc

Need Help on changing ORDER BY sorting technique - 12-11-2007 , 09:41 AM

Re: Need Help on changing ORDER BY sorting technique - 12-11-2007 , 10:30 AM

Re: Need Help on changing ORDER BY sorting technique - 12-11-2007 , 02:08 PM

Re: Need Help on changing ORDER BY sorting technique - 12-12-2007 , 08:48 AM