1 PROF & INT DIV HEAD
2 CELL BIOLOGY & BIOPHYSICS

INTO

1 PROF & INT DIV HEAD CELL BIOLOGY & BIOPHYSICS

Insert into TITLE
   (TITLE)
 Values
   ('ASSISTANT PROFESSOR');
Insert into TITLE
   (TITLE)
 Values
   ('PROFESSOR ADJUNCT');
Insert into TITLE
   (TITLE)
 Values
   ('CLINICAL INSTRUCTOR');
Insert into TITLE
   (TITLE)
 Values
   ('PROF & INT DIV HEAD
CELL BIOLOGY & BIOPHYSICS');
COMMIT;

        {
            "title": "ASSISTANT PROFESSOR"
        },
        {
            "title": "PROFESSOR ADJUNCT"
        },
        {
            "title": "CLINICAL INSTRUCTOR"
        },
        {
            "title": "PROF  INT DIV HEAD
CELL BIOLOGY  BIOPHYSICS"
        }

Parse error on line 779:
...           "title": "PROF  INT DIV HEAD
-----------------------^

trim(replace(replace(replace(um_working_title, '&'), chr(10)||chr(13)), '"')) title

SQL> select '"title":"'||replace(title,chr(10))||'"' from title;
'"TITLE":"'||REPLACE(TITLE,CHR(10))||'"'
------------------------------------------------------------
"title":"ASSISTANT PROFESSOR"
"title":"PROFESSOR ADJUNCT"
"title":"CLINICAL INSTRUCTOR"
"title":"PROF & INT DIV HEADCELL BIOLOGY & BIOPHYSICS"

I used this:

select '"title":"'||replace(title,chr(10))||'"' result from title;

That produced:

1 "title":"PROF & INT DIV HEAD
2 CELL BIOLOGY & BIOPHYSICS"

The result is still broken into 2 lines.

SQL> select rownum, title from title;
    ROWNUM TITLE
---------- --------------------------------------------------
         1 ASSISTANT PROFESSOR
         2 PROFESSOR ADJUNCT
         3 CLINICAL INSTRUCTOR
         4 PROF & INT DIV HEAD
           CELL BIOLOGY & BIOPHYSICS

4 rows selected.

SQL> select '"title":"'||replace(title,chr(10))||'"' from title;
'"TITLE":"'||REPLACE(TITLE,CHR(10))||'"'
------------------------------------------------------------
"title":"ASSISTANT PROFESSOR"
"title":"PROFESSOR ADJUNCT"
"title":"CLINICAL INSTRUCTOR"
"title":"PROF & INT DIV HEADCELL BIOLOGY & BIOPHYSICS"

4 rows selected.

CREATE TABLE TITLE_CABOT
(
  TITLE  VARCHAR2(100 BYTE)
)

Insert into TITLE_CABOT
   (TITLE)
 Values
   ('ASSISTANT PROFESSOR');
Insert into TITLE_CABOT
   (TITLE)
 Values
   ('PROFESSOR ADJUNCT');
Insert into TITLE_CABOT
   (TITLE)
 Values
   ('CLINICAL INSTRUCTOR');
Insert into TITLE_CABOT
   (TITLE)
 Values
   ('PROF & INT DIV HEAD
CELL BIOLOGY & BIOPHYSICS');
COMMIT;

select '"title":"'||replace(title,chr(10))||'"' result from title_cabot;

OR EVEN

select replace(title,chr(10)) result from title_cabot;

SQL> CREATE TABLE TITLE_CABOT
  2  (
  3    TITLE  VARCHAR2(100 BYTE)
  4  )
  5  
SQL> /

Table created.

SQL> Insert into TITLE_CABOT
  2     (TITLE)
  3   Values
  4     ('ASSISTANT PROFESSOR');

1 row created.

SQL> Insert into TITLE_CABOT
  2     (TITLE)
  3   Values
  4     ('PROFESSOR ADJUNCT');

1 row created.

SQL> Insert into TITLE_CABOT
  2     (TITLE)
  3   Values
  4     ('CLINICAL INSTRUCTOR');

1 row created.

SQL> Insert into TITLE_CABOT
  2     (TITLE)
  3   Values
  4     ('PROF & INT DIV HEAD
  5  CELL BIOLOGY & BIOPHYSICS');

1 row created.

SQL> COMMIT;

Commit complete.

SQL> 
SQL> select '"title":"'||replace(title,chr(10))||'"' from title;
'"TITLE":"'||REPLACE(TITLE,CHR(10))||'"'
------------------------------------------------------------
"title":"ASSISTANT PROFESSOR"
"title":"PROFESSOR ADJUNCT"
"title":"CLINICAL INSTRUCTOR"
"title":"PROF & INT DIV HEADCELL BIOLOGY & BIOPHYSICS"

4 rows selected.

SQL*Plus: Release 11.2.0.3.0 Production on Fri Jan 16 11:01:56 2015

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select replace(title,chr(10)) result from title_cabot
  2  /

RESULT
--------------------------------------------------------------------------------

ASSISTANT PROFESSOR
PROFESSOR ADJUNCT
CLINICAL INSTRUCTOR
PROF & DIV HEAD CELL BIOLOGY

SQL> select replace(title,chr(10)) result from title_cabot

JSONRows clob;

for i in (select emplid,
                           case
                             when name_middle <> ' '
                               then
                                 trim(replace(replace(name_last||', '||name_first||' '||name_middle, chr(9)), '"'))
                               else
                                 trim(replace(replace(name_last||', '||name_first, chr(9)), '"'))
                           end name,
                           --trim(replace(replace(replace(um_working_title, '&'), chr(10)||chr(13)), '"')) title,
                           replace(um_working_title, chr(10)) title,
                           descr,
                           phone,
                           address1 address,
                           emailid email,
                           website
                      from faculty_staff_lu.faculty_staff_dir 
                           inner join faculty_staff_lu.department_name on faculty_staff_lu.faculty_staff_dir.deptid = faculty_staff_lu.department_name.deptid
                        where faculty_staff_lu.faculty_staff_dir.deptid = upper(Search) and
                              faculty_staff_lu.faculty_staff_dir.emplid is not null
                          order by name_last, 
                                   name_first)
                           
            loop
              JSON := '{"name": "'||i.name||'", '||
                      '"title": "'||i.title||'", '||
                      '"descr": "'||i.descr||'", '||
                      '"phone": "'||i.phone||'", '||
                      '"address": "'||i.address||'", '||
                      '"email": "'||i.email||'", '||
                      '"website": "'||i.website||'"},';
            
              JSONRows := JSONRows||JSON;
            end loop;
            
            JSONRows := rtrim(JSONRows, ','); 
            JSON := '{"data": ['||JSONRows||']}';

{
            "name": "xxxx",
            "title": "PROF & INT DIV HEAD
CELL BIOLOGY & BIOPHYSICS",
            "descr": "Biology - General",
            "phone": "xxxx",
            "address": "SCB",
            "email": "xxxx",
            "website": "xxxx"
        },

Parse error on line 779:
...           "title": "PROF & INT DIV HEAD
-----------------------^
Expecting 'STRING', 'NUMBER', 'NULL', 'TRUE', 'FALSE', '{', '['

{"name": "xxxxx", "title": "PROF & INT DIV HEAD
CELL BIOLOGY & BIOPHYSICS", "descr": "xxxx", "phone": "xxxx", "address": "xxx", "email": "xxxx", "website": "xxxx"},

replace(replace(um_working_title, chr(10)), chr(13)) title,

{
            "name": "xxx",
            "title": "PROF & INT DIV HEADCELL BIOLOGY & BIOPHYSICS",
            "descr": "xxx",
            "phone": "xxx",
            "address": "xxx",
            "email": "xxx",
            "website": "xxx"
        },

Was this:

{
            "name": "xxxx",
            "title": "PROF & INT DIV HEAD
CELL BIOLOGY & BIOPHYSICS",
            "descr": "Biology - General",
            "phone": "xxxx",
            "address": "SCB",
            "email": "xxxx",
            "website": "xxxx"
        },

Parse error on line 779:
...           "title": "PROF & INT DIV HEAD
-----------------------^
Expecting 'STRING', 'NUMBER', 'NULL', 'TRUE', 'FALSE', '{', '['


To this:

replace(replace(um_working_title, chr(10)), chr(13), ' ') title,

{
            "name": "xxx",
            "title": "PROF & INT DIV HEAD CELL BIOLOGY & BIOPHYSICS",
            "descr": "xxx",
            "phone": "xxx",
            "address": "xxx",
            "email": "xxx",
            "website": "xxx"
        },

trim(replace(replace(replace(um_working_title, '&'), chr(13)||chr(10)), '"')) title

$ cat t
PROF & INT DIV HEAD
CELL BIOLOGY & BIOPHYSICS
$ cat t  | tr '\n' '\r'
CELL BIOLOGY & BIOPHYSICS

$ cat t  | tr '\n' '\r' | od -a
0000000   P   R   O   F  sp   &  sp   I   N   T  sp   D   I   V  sp   H
0000020   E   A   D  cr  cr   C   E   L   L  sp   B   I   O   L   O   G
0000040   Y  sp   &  sp   B   I   O   P   H   Y   S   I   C   S
0000056

replace(replace(um_working_title, chr(10)), chr(13), ' ') title