-
Sort characters in a string
All,
I have a varchar(10) field in a table. I would like to sort the characters within a given string, in this field, in ascending order, using a SQL query.
i.e. If the field has "airlines" ... I would like to have "aeiilnrs" as the result (from my SQL query).
How can I do this?
Thank you for your time.
-
Sorting homework problem? Impress your teacher by using bubble sort and PL/SQL collections.
Bubble sort algorithm:
http://www.cs.princeton.edu/~ah/alg_...ubbleSort.html
Collections:
http://download-west.oracle.com/docs...olls.htm#20425
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|