Shorthand for a 101 year and 3 month interval(INTERVAL '101' YEAR) : INTERVAL « Data Type « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Data Type
  3. INTERVAL

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.








Related examples in the same category

1.Shorthand for a 101 year and 3 month interval(INTERVAL '101-3' YEAR TO MONTH)
2.Shorthand for a 101 year and 3 month interval(INTERVAL '3' MONTH)
3.This script demonstrates the use of the INTERVAL types
4.INTERVAL DAY TO SECOND
5.An assignment to var2