SQL*Plus: Release 3.3.2.0.0 - Production on Fri Jun 12 13:59:13 1998 Copyright (c) Oracle Corporation 1979, 1994. All rights reserved. Connected to: Oracle7 Server Release 7.3.2.1.0 with the 64-bit option - Production Release PL/SQL Release 2.3.2.0.0 - Production SQL> SQL> SQL> Table dropped. SQL> SQL> SQL> 2 3 4 5 6 7 8 Table created. SQL> SQL> SQL> 2 3 1 row created. SQL> SQL> 2 3 1 row created. SQL> SQL> 2 3 1 row created. SQL> SQL> 2 3 1 row created. SQL> SQL> 2 3 1 row created. SQL> SQL> 2 3 1 row created. SQL> SQL> SQL> SQL> 2 3 4 PEN_ID HD_CNT ---------- ---------- 2 43 SQL> SQL> SQL> SQL> SQL> 2 3 PEN_ID HD_CNT FROMDATE TODATE ---------- ---------- --------- --------- 1 43 25-FEB-98 01-MAR-98 1 20 01-MAR-98 14-MAR-98 2 23 01-MAR-98 14-MAR-98 2 43 14-MAR-98 31-DEC-99 SQL> SQL> SQL> SQL> SQL> 2 3 PEN_ID HD_CNT ---------- ---------- 1 43 1 20 2 23 2 43 SQL> SQL> SQL> SQL> 2 3 4 5 6 7 no rows selected SQL> SQL> SQL> SQL> 2 3 4 5 LOT_ID_NUM LOT_ID_NUM PEN_ID ---------- ---------- ---------- 137 219 1 137 219 1 137 374 1 219 374 1 219 374 1 SQL> SQL> SQL> SQL> 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 LOT_ID_NUM LOT_ID_NUM PEN_ID FROMDATE TODATE ---------- ---------- ---------- --------- --------- 219 374 1 25-FEB-98 01-MAR-98 219 374 1 01-MAR-98 14-MAR-98 SQL> SQL> SQL> SQL> 2 3 4 5 6 7 8 9 LOT_ID_NUM LOT_ID_NUM PEN_ID GREATEST( LEAST(L1. ---------- ---------- ---------- --------- --------- 219 374 1 25-FEB-98 01-MAR-98 219 374 1 01-MAR-98 14-MAR-98 SQL> SQL> Disconnected from Oracle7 Server Release 7.3.2.1.0 with the 64-bit option - Production Release PL/SQL Release 2.3.2.0.0 - Production