SQL> SET SERVEROUTPUT ON
SQL> DECLARE
2 faculty_last_name VARCHAR2 (20) := 'Cox';
3 faculty_first_name VARCHAR2 (20) := 'Kim';
4 faculty_phone VARCHAR2 (20) := '7155551234';
5 BEGIN
6 DBMS_OUTPUT.PUT_LINE
7 (faculty_first_name
8 || ' '
9 || faculty_last_name
10 || '''s phone number is ('
11 || SUBSTR (faculty_phone, 1, 3)
12 || ') '
13 || SUBSTR (faculty_phone, 4, 3)
14 || '-'
15 || SUBSTR (faculty_phone, 7));
16 END;
17 /
Kim Cox's phone number is (715) 555-1234
PL/SQL procedure successfully completed.