Re: [SQL] Using Control Flow Functions in a SELECT Statement

[Bricklen Anderson]

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.


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster