Hello,
Your formatter is a annoying. Here is my sql script:
SELECT ppf.person_id
,ppf.full_name
,NVL(ppf.employee_number, ppf.attribute1) emp_num
,UPPER(SUBSTR(ppf.email_address,1,INSTR(ppf.email_address,'@')-1)) email_ID
FROM apps.per_all_assignments_f paa...