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