Oracle: If-else function for non-nulls

Question

Creating a view, I'm trying to find an equivalent 'if-else' function similar to NVL2(). The values I have coming in are guaranteed to be non-null.

theFunction(IS_BOOK == 'Y', 'BOOK', 'SHOW')

CASE WHEN IS_BOOK = 'Y' THEN 'BOOK' ELSE 'SHOW' END – DirkNM Oct 20 '14 at 17:30 — DirkNM, Oct 20 '14 at 17:30

score 2 · Accepted Answer · answered Oct 20 '14 at 17:34

2

You could use DECODE:

DECODE(IS_BOOK, 'Y', 'BOOK', 'SHOW')

answered Oct 20 '14 at 17:34

Alex K.

1 Answers1