Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Another angle on this....
Curious, I'm not the only one in this group with doubts about CASE in PL/SQL
in 8i though.
I did suggest incompetence on my part as a possible explanation, but I think it unlikely in this CASE. I'm certain I tried it, and I'm certain it didn't work because I got so cross that I went and looked in the docs for it (and I've got to be REALLY mad to do that) and didn't find it. Unfortunately I've long since excised 8i from my PC and I'm not going to resurrect it just to investigate an issue that you've correctly pointed out doesn't exist in 9i and which I've devised a workround for anyway. If I can dig out the CD we can compare 8i versions....bated breath.
Regards
"damorgan" <dan.morgan_at_ci.seattle.wa.us> wrote in message
news:3C743505.755B5CCA_at_ci.seattle.wa.us...
> This makes no sense. You can create views in 8i (8.1.7.0.0) with CASE.
>
> I know because I demonstrated it to my class at the university last night.
Now there's serendipity for you.
>
> Daniel Morgan
>
>
>
> Heinz Kiosk wrote:
>
> > > If its not in PL/SQL then thats how I made my mistake. I tested my
> > reporting
> > > views by creating them in PL/SQL in 9i and couldn't get CASE to work.
> > Whoops, I meant 8i of course.
>
Received on Wed Feb 20 2002 - 18:01:54 CST