How to create segment segment from road geometry(sdo_gtype 4002) every 25 meters in sql statement

 how to cut road every 25 meters from a geometry in sql statement.

I have a table road

as follow

( 

id number, 

name varchar2(20)

geom sdo_geometry 

);

containing road geometry as lrs start from 0 meter end to max length in meter

i need to create a query to do clip segment of road from start to end with a distance of 25 meters

the table contain something like this

ID; NAME, GEOM_lrs              geom_length

1   road1  geometry(4002)     55     

2   road2  geometry(4002)     60

3   road3  geometry(4002)     14

the sql statement must return the geometry every 25 meter must contain the geometry. 

if the geom is lower than 25 meter, we return the original geometry