EXPRESSIONS

• 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;