You're right - there is no CASE statement, but you can use DECODE to simulate it:
, DECIMAL_PORT > 0, 'positive value'
, DECIMAL_PORT < 0, 'negative value'
, 'zero' )
It is an equivalent of the following Transact-SQL CASE statement:
WHEN DECIMAL_PORT > 0 THEN 'positive value'
WHEN DECIMAL_PORT < 0 THEN 'negative value'
Here's how it works:
• The 1st parameter is a hard-coded TRUE value,
• Even parameters (2nd, 4th and so on) are the conditions,
• Odd parameters (3rd, 5th and so on) are the return values,
• The last parameter is the default return value,
• The first condition that evaluates to the value of the 1st parameter (i.e. the first condition that is true) determines the value that is returned,
•If none of the conditions is met the last parameter is returned.