Data Type Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Data Type
  4. 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.