Re: views if and case statements

From: Kevin McDaniel <kmcdaniel96_at_home.com>
Date: Wed, 11 Jul 2001 22:27:43 GMT
Message-ID: <zp437.126918$mG4.62993045@news1.mntp1.il.home.com>

You'll find that you can use Oracle Migration Workbench to assist you with this task. However, you might try looking at the DECODE statement in Oracle. I used this statement when converting from SQL Server to Oracle for IF and CASE statements. Good luck.

"CME" <support_at_cmesys.demon.co.uk> wrote in message news:994857820.10530.0.nnrp-02.c2de4217_at_news.demon.co.uk...
> 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
>
>
Received on Wed Jul 11 2001 - 17:27:43 CDT