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

Home -> Community -> Usenet -> c.d.o.tools -> Re: views if and case statements

Re: views if and case statements

From: Daniel A. Morgan <Daniel.Morgan_at_attws.com>
Date: Wed, 11 Jul 2001 08:23:29 -0700
Message-ID: <3B4C6F71.55A718D2@attws.com> 






CME wrote:



> I am trying to convert sybase views to oracle views and I cannot find a way

> to use 'if' or 'case' statements within a view itself

> if there is any way this can be done or can be worked around please contact

> me

> thank you for any help




Look at the DECODE function. That is as close as you can get.



Daniel A. Morgan
Received on Wed Jul 11 2001 - 10:23:29 CDT












Original text of this message













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