order by lower have different result in oracle -


i want sort label lower case, not why have 2 different result ? enter image description here

i expect first result must this:

1a   a_test btest chrismax chrismax t test xmax 2014 

"chrismax" , "chrismax" lowercased same. database can order 2 rows way pleases.


Comments

Popular posts from this blog

ruby on rails - RuntimeError: Circular dependency detected while autoloading constant - ActiveAdmin.register Role -

c++ - OpenMP unpredictable overhead -

javascript - Wordpress slider, not displayed 100% width -