Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table    tour_detail (
  location_id NUMBER(4),
  time interval day to second
  )
insert into tour_detail (location_id, time)
with cte(rnd, n) as (
	select dbms_random.value, 1 from dual
	union all
	select dbms_random.value, n+ 1 from cte where n < 10
)
select 3 as location_id, rnd * 12 * interval '1' hour as time
from cte order by n
10 rows affected

select * from tour_detail


LOCATION_ID
TIME


3
+00 07:13:32.262069

3
+00 03:45:18.965145

3
+00 07:13:41.394986

3
+00 02:24:19.516714

3
+00 11:38:16.000109

3
+00 11:11:47.947329

3
+00 08:14:54.641965

3
+00 02:52:43.090595

3
+00 03:44:26.418538

3
+00 09:29:35.390110

LOCATION_ID	TIME
3	+00 07:13:32.262069
3	+00 03:45:18.965145
3	+00 07:13:41.394986
3	+00 02:24:19.516714
3	+00 11:38:16.000109
3	+00 11:11:47.947329
3	+00 08:14:54.641965
3	+00 02:52:43.090595
3	+00 03:44:26.418538
3	+00 09:29:35.390110