| 1 |
LOWER is a built-in function converting a string into its lower case
|
| 2 |
|| concatenates two strings into one. E.g., 'CPS'||'616' equals 'CPS616' (same as + in Java, . in Perl)
|
| 3 |
pname dbname%TYPE implies PL/SQL variable pname inherits data type of dbname
|
| 4 |
LIKE is a comparison operator such that x LIKE y is TRUE if x does match the pattern y.
|
| 5 |
The character '%' matches any string of zero or more characters
|
| 6 |
The SQL statement looks at rows whose last_name or first_name field has the input string cname as a substring in lower case
|
