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