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!

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,860 views