Sometimes, it is necessary not to leave certain fields empty. Use Nvl() to replace null with another value:

1 SQL> select first_name, Nvl(middle_name, ‘No middle name’) from xactly.xc_participant limit 15;