Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: DECODE
> I thought that the CASE statement did not work in pl/sql in 8i. Perhaps
> I have that backwards? I know is works in plain sql.
I'm wasn't exactly sure. So I had to do some digging in the Oracle docs on this. There is no mention of the CASE function in the SQL Reference manual. But I did find that it was available in a SQL statement in Oracle 8.1.7. The "Getting To Know" does list this as a new feature for 8.1.7. Unless someone knows differently, I'm going to assume that CASE was not available pre-8.1.7. So that does make my original statement in error, but I wouldn't blanket all of 8i with this function.
HTH,
Brian
-- =================================================================== Brian Peasland dba_at_remove_spam.peasland.com Remove the "remove_spam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three"Received on Thu Apr 01 2004 - 17:06:24 CST
![]() |
![]() |