SQL>
SQL> DECLARE
2 B INTERVAL DAY(9) TO SECOND(9);
3
4 FUNCTION double_my_interval (A IN INTERVAL DAY TO SECOND) RETURN INTERVAL DAY TO SECOND
5 IS
6 BEGIN
7 RETURN A * 2;
8 END;
9 BEGIN
10 B := '1 0:0:0.123456789';
11 DBMS_OUTPUT.PUT_LINE(B);
12 DBMS_OUTPUT.PUT_LINE(double_my_interval(B));
13 END;
14 /
PL/SQL procedure successfully completed.
SQL>