I have to investigate error files created by SQL from an Oracle database. I would like to get just the emp number and pass this to another process, to out put specific details relating to that employee.
Typical contents of an error file;
STAFF_NUM TERM_DT DETAIL
------------ ----------- ------------------------
43440 11-AUG-2003 CREW_POSITION_FLY_V
48947 NULL CREW_BASE_V
48947 NULL CREW_CONTRACTS_V
48947 NULL CREW_DETAILS_V
48947 NULL CREW_EMPLOYMENT_STATUS_V
48947 NULL CREW_RANK_V
48947 NULL CREW_RSRC_GRP_V
Can I get just the column with the emp number, stripping of duplicate numbers, and pass this into another script that uses the emp number to produce a detailed report on their history.
Thanks for the help.