I have the following code, which seems to be working. Is there a way I can add a date, timestamp to the type definition? If so, how would reference the columns so I can INSERT data into them. For example, let's say I want to add 10 seconds to SYSDATE and SYSTIMESTAMP for each new row?
create table t ( x int );
declare
type numlist is table of number index by pls_integer;
s numlist;
begin
for i in 1 .. 100000
loop
s(i) := i;
end loop;
forall i in 1 .. 100000
insert into t values (s(i));
end;
/
Using exactly the same method as you did with numbers:
Then
db<>fiddle here