Query to display each ename to arrange in alphabetical order in oracle database?

Question

For example, 'smith' will be displayed as 'himst'
'allen' will be displayed as 'aelln'
'Turner' will be displayed as 'enrrtu'

Answer 1

I haven't tried it, but this looks interesting:
https://stackoverflow.com/questions/2835634/sort-chars-in-varchar2-alphabetically
I would try the trick with "select listagg within group..." if you are on 11i or higher version.