ch10_intervals03.sql

OReilly Oracle PL SQL Programming第4版源代码

/* Adding and subtracting intervals */
DECLARE
   a1 INTERVAL DAY TO SECOND := '2 3:4:5.6';
   b1 INTERVAL DAY TO SECOND := '1 1:1:1.1';

   a2 INTERVAL YEAR TO MONTH := '2-10';
   b2 INTERVAL YEAR TO MONTH := '1-1';

   a3 NUMBER := 3;
   b3 NUMBER := 1;
BEGIN
   DBMS_OUTPUT.PUT_LINE(a1 - b1);
   DBMS_OUTPUT.PUT_LINE(a2 - b2);
   DBMS_OUTPUT.PUT_LINE(a3 - b3);
END;
/


/*======================================================================
| Supplement to the third edition of Oracle PL/SQL Programming by Steven
| Feuerstein with Bill Pribyl, Copyright (c) 1997-2002 O'Reilly &
| Associates, Inc. To submit corrections or find more code samples visit
| http://www.oreilly.com/catalog/oraclep3/
*/