Skip to Main Content
Forums

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!

How to SORT in PARTICULAR type if it is not in Alphabetical order

649638Oct 25 2008 — edited Oct 26 2008
Hi all,

My table PHOTOS HAS COLUMNS

PICID TYPE DATE CUSNAM

1 SHARE 01/05/95 RICHARD

2 ZOOM 02/23/01 MIKE

3 ULTRA 09/08/06 JOHN

2 ZOOM 04/02/99 RACHEL

1 SHARE 01/06/92 MICHEL

3 ULTRA 07/01/97 MARY

HERE IF PICID =1 THEN TYPE SHARE, IF 2 THEN ZOOM ,IF 3 THEN ULTRA. WHERE PICID IS VARCHAR

NOW I HAVE TO SORT MY TABLE (FIRST BY ZOOM,THEN BY SHARE, THEN BY ULTRA) THEN BY DATE

NOW I NEED OUTPUT AS

PICID TYPE DATE CUSNAM

2 ZOOM 04/02/99 RACHEL

2 ZOOM 02/23/01 MIKE

1 SHARE 01/06/92 MICHEL

1 SHARE 01/05/95 RICHARD

3 ULTRA 07/01/97 MARY

3 ULTRA 09/08/06 JOHN
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 23 2008
Added on Oct 25 2008
5 comments
552 views