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

Home -> Community -> Usenet -> comp.databases.oracle -> using case, Valid statement?

using case, Valid statement?

From: Michael Hill <hillmw_at_ram.lmtas.lmco.com>
Date: Thu, 19 Feb 2004 10:27:15 -0600
Message-ID: <4034E3E3.72401616@ram.lmtas.lmco.com>

Is this a valid sql statement:

SELECT
case field1

	 when 'first' then 1 
	 when 'second' then 1 
	 else null 
end 
FROM	mytable

Mike Received on Thu Feb 19 2004 - 10:27:15 CST

Original text of this message

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