SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

sort column based on value

user601042Oct 17 2012 — edited Oct 18 2012

Hi All,
Query result gives ou put like in the following order
CITY NAME

CHENNI
DELHI
LONDON
RIO DEGENERO

How to get output in the following sort order

LONDON
CHENNAI
DELHI
RIO DEGENERO

i dont want to hardcode the column values ..it will be great if i get option to genrate dynamically.

Thanks!

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 15 2012

Added on Oct 17 2012

9 comments

1,756 views