clear markdown feedback
clear markdown feedback
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 3364508 fiddles created (36321 in the last week).

create table my_tbl (shape sdo_geometry);
 hidden batch(es)


insert into my_tbl (shape) values (sdo_geometry('LINESTRING(1 2,3 4)'));
1 rows affected
 hidden batch(es)


-- select -- a.shape.sdo_gtype -- from -- a.my_tbl select treat(shape as sdo_geometry).sdo_gtype from my_tbl
TREAT(SHAPEASSDO_GEOMETRY).SDO_GTYPE
2002
 hidden batch(es)