Re: Using Control Flow Functions in a SELECT Statement

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.