days diff in oracle code example Example: oracle difference between two dates in days v_numvar := dt1-dt2;