Why are functions in this chapter referred to as "single-row" functions?
What's the difference between the NVL and NVL2 functions?
What's the difference between the TO_CHAR and TO_DATE functions when working with date values?
How is the TRUNC function different from the ROUND function?
What functions can be used to search character strings for specific patterns of data?
What's the difference between using the CONCAT function and the concatenation operator (| |) in a SELECT clause?
Which functions can be used to convert the letter case of character values?
Describe a situation that calls for using the DECODE function.
What format model should you use to display the date 25-DEC-09 as Dec. 25?
Why does the function NVL(shipdate, 'Not Shipped') return an error message?