Select roads that are between FROM and TO I have a road table:

 create table road
   (road_id int, 
    name_ nvarchar2(15), 
    from_ nvarchar2(15), 
    to_ nvarchar2(15), 
    sort int
   );
insert into road (road_id,name_,from_,to_,sort) values (4,'Street A','Street 1','Street 2','1');
insert into road (road_id,name_,from_,to_,sort) values (6,'Street A','Street 2','Street 3','2');
insert into road (road_id,name_,from_,to_,sort) values (5,'Street A','Street 3','Street 4','3');
insert into road (road_id,name_,from_,to_,sort) values (3,'Street B','Street VI','Street VII','600');
insert into road (road_id,name_,from_,to_,sort) values (7,'Street B','Street VII','Street VIII','700');
insert into road (road_id,name_,from_,to_,sort) values (1,'Street B','Street VIII','Street IX','800');
insert into road (road_id,name_,from_,to_,sort) values (2,'Street B','Street I','Street II','100');
insert into road (road_id,name_,from_,to_,sort) values (9,'Street B','Street II','Street III','200');
insert into road (road_id,name_,from_,to_,sort) values (11,'Street B','Street III','Street IV','300');
insert into road (road_id,name_,from_,to_,sort) values (8,'Street C','Street X','Street Y','9');
insert into road (road_id,name_,from_,to_,sort) values (10,'Street C','Street Y','Street Z','10');
commit;
select * from road order by name_, sort;

   ROAD_ID NAME_           FROM_           TO_                   SORT
---------- --------------- --------------- --------------- ----------
         4 Street A        Street 1        Street 2                 1
         6 Street A        Street 2        Street 3                 2
         5 Street A        Street 3        Street 4                 3

         2 Street B        Street I        Street II              100
         9 Street B        Street II       Street III             200
        11 Street B        Street III      Street IV              300

    {Gap in Street B}

         3 Street B        Street VI       Street VII             600
         7 Street B        Street VII      Street VIII            700
         1 Street B        Street VIII     Street IX              800

         8 Street C        Street X        Street Y                 9
        10 Street C        Street Y        Street Z                10


Eventually, I would like to make a tool that allows users to select roads between a from_ and a to_ (the values would be entered in parameters). 

To do this, I think I need to make a query that can do something like:

Select roads where the name_ is Street B, between Street II and Street VIII (inclusive).

   ROAD_ID NAME_           FROM_           TO_                   SORT
---------- --------------- --------------- --------------- ----------
         9 Street B        Street II       Street III             200
        11 Street B        Street III      Street IV              300
         3 Street B        Street VI       Street VII             600
         7 Street B        Street VII      Street VIII            700


How can I do this?
select *
from road
connect by (prior to_ = from_ and from_ != 'Street V')
start with name_ = 'Street B' and from_ = 'Street II'
;

   ROAD_ID NAME_      FROM_      TO_              SORT
---------- ---------- ---------- ---------- ----------
         5 Street B   Street II  Street III        200
         6 Street B   Street III Street IV         300
         7 Street B   Street IV  Street V          400


Answer for the updated question:

select road_id, name_, from_, to_, sort
from
(
  select road_id, name_, from_, to_, sort, 
  row_number() over (order by sort) as rn from road
  where name_ = 'Street B'
)
connect by (prior rn + 1 = rn and from_ != 'Street VIII')
start with from_ = 'Street II'
;

   ROAD_ID NAME_           FROM_           TO_                   SORT
---------- --------------- --------------- --------------- ----------
         9 Street B        Street II       Street III             200
        11 Street B        Street III      Street IV              300
         3 Street B        Street VI       Street VII             600
         7 Street B        Street VII      Street VIII            700