0
votes
1answer
52 views

Sort within row

I wonder, if there is a way to sort data inside each row? For example, I have table val1, 3, 2, 1 val2, 2, 3, 1 val3, 3, 1, 2 val4, 1, 3, 2 val5, 1, 2, 3 and want to select it sorted, as val1, 1, ...
8
votes
5answers
3k views

Oracle sort varchar2 column with special characters last

How can I sort in Oracle a Varchar2 or NVarchar2 column to be in my own custom defined order. Or are any existing options available that will put letters first, then numbers, then all special ...