Re: Another angle on this....

From: damorgan <dan.morgan_at_ci.seattle.wa.us>
Date: Thu, 21 Feb 2002 00:53:15 GMT
Message-ID: <3C74450D.E627450C@ci.seattle.wa.us>

I just ran the the following on an 8.1.7.0.0 Oracle instance:

CREATE TABLE sources (

   sourceno NUMBER(10));

INSERT INTO sources VALUES (500);
INSERT INTO sources VALUES (510);
INSERT INTO sources VALUES (511);
INSERT INTO sources VALUES (525);
INSERT INTO sources VALUES (526);

COMMIT; CREATE OR REPLACE VIEW src_view AS
SELECT sourceno, CASE WHEN (sourceno < 510) THEN 'low'

                      WHEN (sourceno between 510 and 525) THEN 'med'
                      ELSE 'high'
                 END note

FROM sources;

SELECT *
FROM src_view;

If you can't get it to work ... then there is something else going on other than Oracle's software.

Daniel Morgan

Heinz Kiosk wrote:

> 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:53:15 CST