DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: case syntax

  1. #1
    Join Date
    Jun 2002
    Posts
    2
    Hi !

    Have a question about case. We have the following SQL that works in 8.1.7 but not in 8.0.6. What can be the reason ?

    Best Regards,

    Staffan Olofsson

  2. #2
    Join Date
    Jun 2002
    Posts
    2

    Smile Here is the SQL too

    select sysdate,
    (CASE
    sysdate < to_date('20020613','YYYYMMDD')
    then 1 else 0
    end) as test
    from dual


  3. #3
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448
    Hello;

    The only reason is that in 8.0.5 the SQL-CASE-Expression is not yet imlemented as feature.
    View the New-Features Documents of 8.1.x

    Oraca

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width