How to sort query filename output like Windows explorer?

Database Administrators Asked by Gunnar on October 28, 2021

i would like to order my query output the way Windows Explorer does.

First special characters like _, then the numbers, and the letters last.

_ttt.bmp
0.gif
bbb.png

oracle order by

One Answer

Try setting your NLS_SORT to PUNCTUATION or XPUNCTUATION before running the query:

ALTER SESSION SET NLS_SORT = 'XPUNCTUATION';

Answered by Daren Beattie on October 28, 2021

Add your own answers!

Ask a Question

Get help from others!

Recent Answers

Peter Machado on Why fry rice before boiling?
Lex on Does Google Analytics track 404 page responses as valid page views?
haakon.io on Why fry rice before boiling?
Joshua Engel on Why fry rice before boiling?
Jon Church on Why fry rice before boiling?

Recent Questions

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP