Assume Authors has VARCHAR2 columns au_Fname and au_Lname with these rows. NULL means a missing value, not the text "NULL".
| au_Fname | au_Lname |
|---|
| Sarah | Buchman |
| NULL | Kellsey |
Queries to interpret
SELECT au_Fname || ' ' || au_Lname AS FullName
FROM Authors;
SELECT SUBSTR(au_Lname, 1, 3) AS LastNamePrefix
FROM Authors;
- Write the output of each query for both sample rows. Without ORDER BY, row order is not guaranteed.
- Explain the space literal and the two numeric arguments to SUBSTR.
- Explain what happens to the concatenated value when au_Fname is NULL in Oracle.