Mega Code Archive
Shorthand for a 101 year and 3 month interval(INTERVAL 3 MONTH)
SQL>
SQL> DECLARE
2 var2 INTERVAL YEAR(3) TO MONTH;
3 BEGIN
4 -- Shorthand for a 101 year and 3 month interval.
5 var2 := INTERVAL '3' MONTH;
6 END;
7 /
PL/SQL procedure successfully completed.