Re: Using Control Flow Functions in a SELECT Statement

Hi Team

Thanks FOR your prompt response....But USING CASE issue still NOT resolved
....Oracle prompts same error.

Team its a simple query but really instresting one...

Following data has been updated IN TABLE DVDs

INSERT INTO DVDs (Name, NumDisks, RatingID, StatID)

VALUES('Mash', 2, 'R', 's2'), ('View', 1, 'NR', 's1'), ('Show', 2, 'NR',
's2'), ('Amadeus', 1, 'PG', 's2') , ('Falcon', 1, 'NR', 's2'),

('Africa', 1, 'PG', 's1'), ('Doc', 1, 'G', 's2') , ('Christmas', 1, 'NR',
's1');

On 12/4/06, Bricklen Anderson <banderson(at)presinet(dot)com> wrote:
>
> Ashish Ahlawat wrote:
> >
> > Hi Team
> >
> > I am unable to fetch data using following simple query it prompts
> > following error
> >
> > *ORA: 00907: Missing right parenthesis*
> >
> > Query :-
> >
> > SELECT
> >
> > Name AS Title, StatID AS Status, RatingID AS Rating,
> >
> > IF(NumDisks>1, 'Check for extra disks!', 'Only 1 disk.') AS Verify
> >
>
> i. That's an Oracle error message.
> ii. IF does not belong in an SQL query. Use CASE.
>
>