INTERVAL « Data Type « Oracle PL / SQL






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