By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table my_table (shape sdo_geometry);
begin
insert into my_table (shape) values (sdo_geometry('linestring(100 200, 300 400, 500 600)'));
insert into my_table (shape) values (sdo_geometry('linestring(700 800, 900 1000)'));
end;
/
1 rows affected
select *
from all_source s
match_recognize (
partition by owner, name, origin_con_id
order by line
all rows per match
pattern (gc any_* end_?)
define
gc as text like '%get_coord%',
any_ as text not like '%;%'
)
where owner = 'MDSYS'
and name = 'SDO_UTIL'
and origin_con_id = 1
| OWNER | NAME | ORIGIN_CON_ID | LINE | TYPE | TEXT |
|---|---|---|---|---|---|
| MDSYS | SDO_UTIL | 1 | 671 | PACKAGE | FUNCTION get_coordinate(geometry in mdsys.sdo_geometry, |
| MDSYS | SDO_UTIL | 1 | 672 | PACKAGE | coord_index in number) |
| MDSYS | SDO_UTIL | 1 | 673 | PACKAGE | RETURN MDSYS.SDO_GEOMETRY DETERMINISTIC PARALLEL_ENABLE; |
create index idx1
on my_table (treat(
mdsys.sdo_util.get_coordinate(shape,1)
as sdo_geometry
).sdo_point.x
);
create index idx12
on my_table(shape.sdo_point.x);