By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table test_table (shape sdo_geometry);
begin
insert into test_table (shape) values (sdo_geometry('linestring(10 20, 30 40, 50 60)'));
insert into test_table (shape) values (sdo_geometry('linestring(70 80, 90 100)'));
insert into test_table (shape) values (sdo_geometry('linestring(110 120, 130 140, 150 160, 170 180)'));
end;
/
1 rows affected
select
(shape).sdo_ordinates as sdo_ordinate_array
from
test_table
create or replace TYPE SDO_ORDINATE_ARRAY AS VARRAY(1048576) OF NUMBER