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

Home -> Community -> Mailing Lists -> Oracle-L -> querry..

querry..

From: Saurabh Sharma <saurabhs_at_fcsltd.com>
Date: Thu, 31 May 2001 02:40:33 -0700
Message-ID: <F001.003151D3.20010531005021@fatcity.com>

hi list,
 

how can i select two columns from a
table based on condition that they are selected in specified combinations.
 

let me..
table 1 has 2 columns col1, col2.
both cols have values , say, alphabets. a,b,c,d,e,f,... i'want to select like
 

FOR VALUE OF COL1 IN A,  col2
must fetch only between A-E
for value of col1 in B, col2 must
be between A-X

--

 and so on..
 
i want to define this combination, so i should get only these pair of values.
 
any suggestions. thanks.
 
saurabh
Received on Thu May 31 2001 - 04:40:33 CDT

Original text of this message

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