Single-row functions return a single result row for every row of a queried table or view. These functions can appear in select lists, WHERE clauses, STARTWITH and CONNECTBY clauses, and HAVING clauses ...