Oracle 18c

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

create table logs (id number, log_tags varchar2(4000));
begin
    insert into logs (id, log_tags) values ( 1,'<Event time="Sat Apr 15 1:13:17.750" type="Debug" thread="2fec: Main CIM worker thread" elapsed="0" ');
    insert into logs (id, log_tags) values ( 2,'Database: C:\2023 Files\GDBs_4\New Mobile Geodatabase.geodatabase');
    insert into logs (id, log_tags) values ( 3,'      SQL: SELECT main.ACTIVE_TRANSPORTATION.OBJECTID,main.active_transportation_nt_flag_vw.flag FRO');
    insert into logs (id, log_tags) values ( 4,'</Event>');
    
    insert into logs (id, log_tags) values ( 5,'<Event time="Sat Apr 15 1:13:17.749" type="Debug" thread="2fec: Main CIM worker thread" elapsed="1" ');
    insert into logs (id, log_tags) values ( 6,null);
    insert into logs (id, log_tags) values ( 7,'</Event>');
    
    insert into logs (id, log_tags) values ( 8,'<Event time="Sat Apr 15 1:13:17.749" type="Debug" thread="2fec: Main CIM worker thread" elapsed="2" ');
    insert into logs (id, log_tags) values ( 9,'Database: C:\2023 Files\GDBs_4\New Mobile Geodatabase.geodatabase');
    insert into logs (id, log_tags) values (10,'      SQL: SELECT main.ACTIVE_TRANSPORTATION.OBJECTID,main.active_transportation_nt_flag_vw.flag FRO');
    insert into logs (id, log_tags) values (11,'      Number of features returned: 100');
    insert into logs (id, log_tags) values (12,'</Event>');
    
    insert into logs (id, log_tags) values (13,'<Event time="Sat Apr 15 1:13:17.749" type="Debug" thread="2fec: Main CIM worker thread" elapsed="0" ');
    insert into logs (id, log_tags) values (14,null);
    insert into logs (id, log_tags) values (15,'</Event>');
    
    insert into logs (id, log_tags) values (16,'<Event time="Sat Apr 15 1:13:17.747" type="Debug" thread="2fec: Main CIM worker thread" elapsed="0" ');
    insert into logs (id, log_tags) values (17,'Database: C:\2023 Files\GDBs_4\New Mobile Geodatabase.geodatabase');
    insert into logs (id, log_tags) values (18,'      SQL: SELECT main.ACTIVE_TRANSPORTATION.OBJECTID,main.active_transportation_nt_flag_vw.flag FRO');
    insert into logs (id, log_tags) values (19,'</Event>');
    
    insert into logs (id, log_tags) values (20,'<Event time="Sat Apr 15 1:13:17.747" type="Debug" thread="2fec: Main CIM worker thread" elapsed="2" ');
    insert into logs (id, log_tags) values (21,'Database: C:\2023 Files\GDBs_4\New Mobile Geodatabase.geodatabase');
    insert into logs (id, log_tags) values (22,'      SQL: SELECT main.ACTIVE_TRANSPORTATION.OBJECTID,main.active_transportation_nt_flag_vw.flag FRO');
    insert into logs (id, log_tags) values (23,'      Number of features returned: 100');
    insert into logs (id, log_tags) values (24,'</Event>');
    
    insert into logs (id, log_tags) values (25,'<Event time="Sat Apr 15 1:13:17.746" type="Debug" thread="2fec: Main CIM worker thread" elapsed="1" ');
    insert into logs (id, log_tags) values (26,null);
    insert into logs (id, log_tags) values (27,'</Event>');
    
    insert into logs (id, log_tags) values (28,'<Event time="Sat Apr 15 1:13:17.746" type="Debug" thread="2fec: Main CIM worker thread" elapsed="0" ');
1 rows affected

select
    id,
    log_tags
from
    logs


ID
LOG_TAGS


1
<Event time="Sat Apr 15 1:13:17.750" type="Debug" thread="2fec: Main CIM worker thread" elapsed="0"

2
Database: C:\2023 Files\GDBs_4\New Mobile Geodatabase.geodatabase

3
      SQL: SELECT main.ACTIVE_TRANSPORTATION.OBJECTID,main.active_transportation_nt_flag_vw.flag FRO

4
</Event>

5
<Event time="Sat Apr 15 1:13:17.749" type="Debug" thread="2fec: Main CIM worker thread" elapsed="1"

6
null

7
</Event>

8
<Event time="Sat Apr 15 1:13:17.749" type="Debug" thread="2fec: Main CIM worker thread" elapsed="2"

9
Database: C:\2023 Files\GDBs_4\New Mobile Geodatabase.geodatabase

10
      SQL: SELECT main.ACTIVE_TRANSPORTATION.OBJECTID,main.active_transportation_nt_flag_vw.flag FRO

11
      Number of features returned: 100

12
</Event>

13
<Event time="Sat Apr 15 1:13:17.749" type="Debug" thread="2fec: Main CIM worker thread" elapsed="0"

14
null

15
</Event>

16
<Event time="Sat Apr 15 1:13:17.747" type="Debug" thread="2fec: Main CIM worker thread" elapsed="0"

17
Database: C:\2023 Files\GDBs_4\New Mobile Geodatabase.geodatabase

18
      SQL: SELECT main.ACTIVE_TRANSPORTATION.OBJECTID,main.active_transportation_nt_flag_vw.flag FRO

19
</Event>

20
<Event time="Sat Apr 15 1:13:17.747" type="Debug" thread="2fec: Main CIM worker thread" elapsed="2"

21
Database: C:\2023 Files\GDBs_4\New Mobile Geodatabase.geodatabase

22
      SQL: SELECT main.ACTIVE_TRANSPORTATION.OBJECTID,main.active_transportation_nt_flag_vw.flag FRO

23
      Number of features returned: 100

24
</Event>

25
<Event time="Sat Apr 15 1:13:17.746" type="Debug" thread="2fec: Main CIM worker thread" elapsed="1"

26
null

27
</Event>

28
<Event time="Sat Apr 15 1:13:17.746" type="Debug" thread="2fec: Main CIM worker thread" elapsed="0"

29
null

30
</Event>

31
<Event time="Sat Apr 15 1:13:17.744" type="Debug" thread="2fec: Main CIM worker thread" elapsed="0"

32
Database: C:\2023 Files\GDBs_4\New Mobile Geodatabase.geodatabase

33
      SQL: SELECT main.ACTIVE_TRANSPORTATION.OBJECTID,main.active_transportation_nt_flag_vw.flag FRO

34
</Event>

35
<Event time="Sat Apr 15 1:13:17.743" type="Debug" thread="2fec: Main CIM worker thread" elapsed="1"

36
null

37
</Event>


select
    id,
    case 
        when substr(log_tags,1,6) = '<Event'  then 'start' 
        when substr(log_tags,1,7) = '</Event' then 'end'
    end as tag_start_end,
    log_tags
from
    logs


ID
TAG_START_END
LOG_TAGS


1
start
<Event time="Sat Apr 15 1:13:17.750" type="Debug" thread="2fec: Main CIM worker thread" elapsed="0"

2
null
Database: C:\2023 Files\GDBs_4\New Mobile Geodatabase.geodatabase

3
null
      SQL: SELECT main.ACTIVE_TRANSPORTATION.OBJECTID,main.active_transportation_nt_flag_vw.flag FRO

4
end
</Event>

5
start
<Event time="Sat Apr 15 1:13:17.749" type="Debug" thread="2fec: Main CIM worker thread" elapsed="1"

6
null
null

7
end
</Event>

8
start
<Event time="Sat Apr 15 1:13:17.749" type="Debug" thread="2fec: Main CIM worker thread" elapsed="2"

9
null
Database: C:\2023 Files\GDBs_4\New Mobile Geodatabase.geodatabase

10
null
      SQL: SELECT main.ACTIVE_TRANSPORTATION.OBJECTID,main.active_transportation_nt_flag_vw.flag FRO

11
null
      Number of features returned: 100

12
end
</Event>

13
start
<Event time="Sat Apr 15 1:13:17.749" type="Debug" thread="2fec: Main CIM worker thread" elapsed="0"

14
null
null

15
end
</Event>

16
start
<Event time="Sat Apr 15 1:13:17.747" type="Debug" thread="2fec: Main CIM worker thread" elapsed="0"

17
null
Database: C:\2023 Files\GDBs_4\New Mobile Geodatabase.geodatabase

18
null
      SQL: SELECT main.ACTIVE_TRANSPORTATION.OBJECTID,main.active_transportation_nt_flag_vw.flag FRO

19
end
</Event>

20
start
<Event time="Sat Apr 15 1:13:17.747" type="Debug" thread="2fec: Main CIM worker thread" elapsed="2"

21
null
Database: C:\2023 Files\GDBs_4\New Mobile Geodatabase.geodatabase

22
null
      SQL: SELECT main.ACTIVE_TRANSPORTATION.OBJECTID,main.active_transportation_nt_flag_vw.flag FRO

23
null
      Number of features returned: 100

24
end
</Event>

25
start
<Event time="Sat Apr 15 1:13:17.746" type="Debug" thread="2fec: Main CIM worker thread" elapsed="1"

26
null
null

27
end
</Event>

28
start
<Event time="Sat Apr 15 1:13:17.746" type="Debug" thread="2fec: Main CIM worker thread" elapsed="0"

29
null
null

30
end
</Event>

31
start
<Event time="Sat Apr 15 1:13:17.744" type="Debug" thread="2fec: Main CIM worker thread" elapsed="0"

32
null
Database: C:\2023 Files\GDBs_4\New Mobile Geodatabase.geodatabase

33
null
      SQL: SELECT main.ACTIVE_TRANSPORTATION.OBJECTID,main.active_transportation_nt_flag_vw.flag FRO

34
end
</Event>

35
start
<Event time="Sat Apr 15 1:13:17.743" type="Debug" thread="2fec: Main CIM worker thread" elapsed="1"

36
null
null

37
end
</Event>

ID	LOG_TAGS
1	<Event time="Sat Apr 15 1:13:17.750" type="Debug" thread="2fec: Main CIM worker thread" elapsed="0"
2	Database: C:\2023 Files\GDBs_4\New Mobile Geodatabase.geodatabase
3	SQL: SELECT main.ACTIVE_TRANSPORTATION.OBJECTID,main.active_transportation_nt_flag_vw.flag FRO
4	</Event>
5	<Event time="Sat Apr 15 1:13:17.749" type="Debug" thread="2fec: Main CIM worker thread" elapsed="1"
6	null
7	</Event>
8	<Event time="Sat Apr 15 1:13:17.749" type="Debug" thread="2fec: Main CIM worker thread" elapsed="2"
9	Database: C:\2023 Files\GDBs_4\New Mobile Geodatabase.geodatabase
10	SQL: SELECT main.ACTIVE_TRANSPORTATION.OBJECTID,main.active_transportation_nt_flag_vw.flag FRO
11	Number of features returned: 100
12	</Event>
13	<Event time="Sat Apr 15 1:13:17.749" type="Debug" thread="2fec: Main CIM worker thread" elapsed="0"
14	null
15	</Event>
16	<Event time="Sat Apr 15 1:13:17.747" type="Debug" thread="2fec: Main CIM worker thread" elapsed="0"
17	Database: C:\2023 Files\GDBs_4\New Mobile Geodatabase.geodatabase
18	SQL: SELECT main.ACTIVE_TRANSPORTATION.OBJECTID,main.active_transportation_nt_flag_vw.flag FRO
19	</Event>
20	<Event time="Sat Apr 15 1:13:17.747" type="Debug" thread="2fec: Main CIM worker thread" elapsed="2"
21	Database: C:\2023 Files\GDBs_4\New Mobile Geodatabase.geodatabase
22	SQL: SELECT main.ACTIVE_TRANSPORTATION.OBJECTID,main.active_transportation_nt_flag_vw.flag FRO
23	Number of features returned: 100
24	</Event>
25	<Event time="Sat Apr 15 1:13:17.746" type="Debug" thread="2fec: Main CIM worker thread" elapsed="1"
26	null
27	</Event>
28	<Event time="Sat Apr 15 1:13:17.746" type="Debug" thread="2fec: Main CIM worker thread" elapsed="0"
29	null
30	</Event>
31	<Event time="Sat Apr 15 1:13:17.744" type="Debug" thread="2fec: Main CIM worker thread" elapsed="0"
32	Database: C:\2023 Files\GDBs_4\New Mobile Geodatabase.geodatabase
33	SQL: SELECT main.ACTIVE_TRANSPORTATION.OBJECTID,main.active_transportation_nt_flag_vw.flag FRO
34	</Event>
35	<Event time="Sat Apr 15 1:13:17.743" type="Debug" thread="2fec: Main CIM worker thread" elapsed="1"
36	null
37	</Event>

ID	TAG_START_END	LOG_TAGS
1	start	<Event time="Sat Apr 15 1:13:17.750" type="Debug" thread="2fec: Main CIM worker thread" elapsed="0"
2	null	Database: C:\2023 Files\GDBs_4\New Mobile Geodatabase.geodatabase
3	null	SQL: SELECT main.ACTIVE_TRANSPORTATION.OBJECTID,main.active_transportation_nt_flag_vw.flag FRO
4	end	</Event>
5	start	<Event time="Sat Apr 15 1:13:17.749" type="Debug" thread="2fec: Main CIM worker thread" elapsed="1"
6	null	null
7	end	</Event>
8	start	<Event time="Sat Apr 15 1:13:17.749" type="Debug" thread="2fec: Main CIM worker thread" elapsed="2"
9	null	Database: C:\2023 Files\GDBs_4\New Mobile Geodatabase.geodatabase
10	null	SQL: SELECT main.ACTIVE_TRANSPORTATION.OBJECTID,main.active_transportation_nt_flag_vw.flag FRO
11	null	Number of features returned: 100
12	end	</Event>
13	start	<Event time="Sat Apr 15 1:13:17.749" type="Debug" thread="2fec: Main CIM worker thread" elapsed="0"
14	null	null
15	end	</Event>
16	start	<Event time="Sat Apr 15 1:13:17.747" type="Debug" thread="2fec: Main CIM worker thread" elapsed="0"
17	null	Database: C:\2023 Files\GDBs_4\New Mobile Geodatabase.geodatabase
18	null	SQL: SELECT main.ACTIVE_TRANSPORTATION.OBJECTID,main.active_transportation_nt_flag_vw.flag FRO
19	end	</Event>
20	start	<Event time="Sat Apr 15 1:13:17.747" type="Debug" thread="2fec: Main CIM worker thread" elapsed="2"
21	null	Database: C:\2023 Files\GDBs_4\New Mobile Geodatabase.geodatabase
22	null	SQL: SELECT main.ACTIVE_TRANSPORTATION.OBJECTID,main.active_transportation_nt_flag_vw.flag FRO
23	null	Number of features returned: 100
24	end	</Event>
25	start	<Event time="Sat Apr 15 1:13:17.746" type="Debug" thread="2fec: Main CIM worker thread" elapsed="1"
26	null	null
27	end	</Event>
28	start	<Event time="Sat Apr 15 1:13:17.746" type="Debug" thread="2fec: Main CIM worker thread" elapsed="0"
29	null	null
30	end	</Event>
31	start	<Event time="Sat Apr 15 1:13:17.744" type="Debug" thread="2fec: Main CIM worker thread" elapsed="0"
32	null	Database: C:\2023 Files\GDBs_4\New Mobile Geodatabase.geodatabase
33	null	SQL: SELECT main.ACTIVE_TRANSPORTATION.OBJECTID,main.active_transportation_nt_flag_vw.flag FRO
34	end	</Event>
35	start	<Event time="Sat Apr 15 1:13:17.743" type="Debug" thread="2fec: Main CIM worker thread" elapsed="1"
36	null	null
37	end	</Event>