-
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
-
Here is the SQL too
select sysdate,
(CASE
sysdate < to_date('20020613','YYYYMMDD')
then 1 else 0
end) as test
from dual
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|