This week's book giveaway is in the Mac OS forum.
We're giving away four copies of a choice of "Take Control of Upgrading to Yosemite" or "Take Control of Automating Your Mac" and have Joe Kissell on-line!
See this thread for details.
The moose likes JDBC and the fly likes sorting multiple columns Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

JavaRanch » Java Forums » Databases » JDBC
Bookmark "sorting multiple columns" Watch "sorting multiple columns" New topic

sorting multiple columns

Shiv Sidhaarth
Ranch Hand

Joined: Aug 06, 2001
Posts: 119
How do i sort multiple columns in Oracle using lower? ie. When i say, lower(Name), result is like this :
I want to give first Name as well as last name in sorting with lower. Hope i am clear.
prabhat kumar
Ranch Hand

Joined: Apr 11, 2001
Posts: 114
order by tolower(colname)
Leslie Chaim
Ranch Hand

Joined: May 22, 2002
Posts: 336
order by lower(first_name || last_name)

Normal is in the eye of the beholder
GeeCON Prague 2014
subject: sorting multiple columns