SQL statement
 SET HEADING OFF
 SPOOL file.txt
 SELECT 'NUMBER|FIRST|LAST|ID' FROM DUAL;
 SELECT EMPLID ||'|'|| FIRST_NAME || '|' || LAST_NAME || '|' || ID FROM db.VIEW WHERE (length(AS_UNIV_ID)>1) and (length(EMPLID)=9) and (length(FIRST_NAME)>1) and (length(LAST_NAME)>1);
 SPOOL OFF