0

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

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

25th Mar 2021, 1:55 PM
Rajan
1 Réponse
0
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.
30th Mar 2021, 11:43 AM
Tibor Santa
Tibor Santa - avatar