Code Listing 14: Query that demonstrates the LENGTH function
SQL> select first_name, LENGTH(first_name) length 2 from
employee 3 order by length desc, first_name; a query that uses
the LENGTH function to display the length of all FIRST_NAME
values from the EMPLOYEE table. The online version of this
article at bit.ly/ JAQPk3 includes examples of LENGTH and other
character functions in WHERE and ORDER BY clauses. 8 rows
selected. SQL> select INSTR('Mississippi', 'issi', 2 from dual;
you with this task. Listing 12 shows a query that uses the
SUBSTR function to extract the first three characters of every
LAST_NAME value from the EMPLOYEE table. The SUBSTR function
takes two required parameters and one optional input parameter.
The first parameter is the literal or column value on which you
want the SUBS TR function to operate. The second parameter is
the position of the starting character for the substring, and
the optional third parameter is the number of characters to be
included in the substring. If the third