Re: From case when... on SQLServer to decode
From: Mark D Powell <mark.powell_at_eds.com>
Date: 12 Apr 2002 06:17:42 -0700
Message-ID: <178d2795.0204120517.7c8ef50_at_posting.google.com>
WHERE rownum < 10 ;
Date: 12 Apr 2002 06:17:42 -0700
Message-ID: <178d2795.0204120517.7c8ef50_at_posting.google.com>
brotherhou_at_yahoo.com (konghou) wrote in message news:<c19678a1.0204120148.69856d4f_at_posting.google.com>...
> How to rewrite case when on SQLServer onto oracle? when the decode
> function on oracle can't handle >, <, !=......
If you have Oracle 8.1+ then why not use the case statement?
SELECT CASE WHEN rownum > 07 THEN 'big time'
WHEN rownum < 04 THEN 'small fry'
ELSE 'middle management' END as "CASE WHEN"
FROM all_tables
WHERE rownum < 10 ;
HTH -- Mark D Powell -- Received on Fri Apr 12 2002 - 15:17:42 CEST