Forum OpenACS Q&A: oracle support for case when...

Collapse
1: oracle support for case when...
Posted by Dan Wickstrom on 02/05/03 06:07 PM
Does anybody recall the version when oracle started supporting case when statements?  Was it 8.1.7?
Collapse
2: Re: oracle support for case when... (response to 1)
Posted by Jonathan Ellis on 02/06/03 12:02 AM
I think it was actually 8.1.6...
Collapse
3: Re: oracle support for case when... (response to 1)
Posted by Don Baccus on 02/06/03 01:55 AM
I couldn't get it to work in 8.1.6 but a quick search on Google clued me in to why that might be true:

"CASE was introdiced in Oracle 8i, but only in SQL, not in PL/SQL.
It is available both in SQL and PL/SQL in Oracle 9i."

I was probably trying it in a PL/SQL statement ...

I have 8.1.6 here I'll try to remember to test it in SQL, would be nice to get rid of some of the Oracle-specific queries in the toolket!

Collapse
4: Re: oracle support for case when... (response to 3)
Posted by Brian Fenton on 02/06/03 10:10 AM
Tom Kyte talks about this on his site and shows a workaround using dynamic SQL. Here's one example: http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:4333097088785