]>
Commit | Line | Data |
---|---|---|
f0df8832 | 1 | set head off |
2 | set feedback off | |
3 | set pagesize 0 | |
64a3f7c0 | 4 | set linesize 331 |
f0df8832 | 5 | spool /moira/load/staff.input.unsorted |
64a3f7c0 | 6 | select mit_id || rpad(nvl(last_name, ' '), 30, ' ') || rpad(nvl(first_name, ' '), 30, ' ') || rpad(nvl(middle_name, ' '), 30, ' ') || rpad(substr(nvl(office_location, ' '), 0, 12), 12, ' ') || rpad(substr(nvl(secondary_office_location, ' '), 0, 12), 12, ' ') || lpad(substr(nvl(office_phone, ' '), 0, 12), 12, ' ') || lpad(substr(nvl(secondary_office_phone, ' '), 0, 12), 12, ' ') || rpad(substr(department_name, 0, 50), 50, ' ') || substr(directory_title, 0, 50) from wareuser.moira_employee; |
f0df8832 | 7 | spool off |
8 | quit |