Mega Code Archive

 

Categories / Oracle PLSQL / Data Type

 

Shorthand for a 101 year and 3 month interval(INTERVAL 101-3 YEAR TO MONTH)

SQL> SQL> DECLARE   2    var2 INTERVAL YEAR(3) TO MONTH;   3  BEGIN   4         5      var2 := INTERVAL '101-3' YEAR TO MONTH;   6  END;   7  / PL/SQL procedure successfully completed.