declare
l_data sys.odciNumberList :=
sys.odciNumberList
( 35, 34, 33, 34, 35,
36, 37, 36, 35, 34, 35,
36, 37 );
l_cnt number := l_data.count;
begin
for i in 1 .. l_cnt
loop
insert into stocks
( symbol, tstamp, price )
values
('XYZ', sysdate-l_cnt+i,
l_data(i) );
end loop;
commit;
end;
/
Tuesday, 3 December 2013
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment