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

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