source:
trunk/third/moira/regtape/staff.sql
@
23095
| Revision 23095, 610 bytes checked in by ghudson, 16 years ago (diff) |
|---|
| Line | |
|---|---|
| 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.
