CURSOR expression An embedded or inline cursor inside a calling SQL statement:
SELECT ...,CURSOR(<subquery>),... FROM ...;
CASE expression An embedded or inline CASE statement inside a SQL statement as a simple CASE statement:
SELECT ... CASE expression WHEN condition THEN ... WHEN condition THEN ... ELSE ... END FROM table;
Or a search CASE statement:
SELECT ... CASE WHEN <condition> THEN ... WHEN <condition> THEN ... ELSE ... END FROM table;