File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "sorting multiple columns" Watch "sorting multiple columns" New topic
Author

sorting multiple columns

Shiv Sidhaarth
Ranch Hand

Joined: Aug 06, 2001
Posts: 119
Hi,
How do i sort multiple columns in Oracle using lower? ie. When i say, lower(Name), result is like this :
Anand
ananthu
Bright
babu
I want to give first Name as well as last name in sorting with lower. Hope i am clear.
Thanks,
Sankar
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: sorting multiple columns