Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> How to display the return this way?

How to display the return this way?

From: C Chang <cschang_at_maxinter.net>
Date: Fri, 14 Dec 2001 10:47:37 -0500
Message-ID: <3C1A1F19.1421@maxinter.net>


I have a select script such as:

Select A, B
from myTable

where A = 'A1' 
or A = 'D1'
or A = 'C1' 
or A = 'B1';

How do I let my return display as my order in where clause:

A1 Bxx
D1 BXXX
C1 BX
B1 Byy

but not in sorted order of column A -> A1, B1, C1, D1.

C Chang Received on Fri Dec 14 2001 - 09:47:37 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US