source:
trunk/third/moira/regtape/staff.sql
@
23095
| Revision 23095, 610 bytes checked in by ghudson, 16 years ago (diff) |
|---|
| Rev | Line | |
|---|---|---|
| [23095] | 1 | set head off |
| 2 | set feedback off | |
| 3 | set pagesize 0 | |
| 4 | set linesize 331 | |
| 5 | spool /moira/load/staff.input.unsorted | |
| 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; | |
| 7 | spool off | |
| 8 | quit |
Note: See TracBrowser
for help on using the repository browser.
