>
>
> How do I change the view to display the result as?
>
> ID FULLNAME
> 1 Dr. Abraham Thomas
> 2 Annelie Mans
> 3 Ms. Chameney Engelbrecht
> 4 Colin Forbes
>

I figured it out:

CREATE OR ALTER VIEW V_USER_INFO(
ID,
DESCRIPTION)
AS
SELECT
USERS.ID, TRIM((COALESCE(CT_TITLES.DESCRIPTION, '') || ' ' || USERS.FULL_NAME)) AS DESCRIPTION
FROM CT_TITLES
RIGHT OUTER JOIN USERS ON (CT_TITLES.ID = USERS.CT_TITLES_ID)