Oracle 18c

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  