Oracle 11g Release 2

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

create table t (id NUMBER(5,0), txt varchar (1000));
insert into t (id, txt) values
(
1,
'
AAAAAAAAAAAAAAAAAAAAAAAAAAAA  BBBB    CCCCCCCCCCCCCCCCCCCCCCCCC
DDDE  FFFFFFFF    GGGGGGGGG               HHHHHHHH    IIIIIII
JJ      KKKLLL       MM NN                              OOOOO
            P                                              QQ
'
);
1 rows affected

insert into t (id, txt) values ( 2, 'RRRSTT UUU    V WXYZ' );
1 rows affected

WITH lines ( txt, id, line, pos, line_no ) AS(
  SELECT txt,
         id,
         REGEXP_SUBSTR( txt, '.*', 1, 1 ),
         REGEXP_INSTR( txt, '.*', 1, 1, 1 ),
         1
  FROM   t
UNION ALL
  SELECT txt,
         id,
         REGEXP_SUBSTR( txt, '.*', pos + 1, 1 ),
         REGEXP_INSTR( txt, '.*', pos + 1, 1, 1 ),
         line_no + 1
  FROM   lines
  WHERE  pos > 0
),
words ( id, line, line_no, section_start, section_end, section_value ) AS (
  SELECT id,
         line,
         line_no,
         REGEXP_INSTR( line, '(\S)\1*', 1, 1, 0 ),
         REGEXP_INSTR( line, '(\S)\1*', 1, 1, 1 ) - 1,
         REGEXP_SUBSTR( line, '(\S)\1*', 1, 1, NULL, 1 )
  FROM   lines
  WHERE  pos > 0
  AND    line IS NOT NULL
UNION ALL
  SELECT id,
         line,
         line_no,
         REGEXP_INSTR( line, '(\S)\1*', section_end + 1, 1, 0 ),
         REGEXP_INSTR( line, '(\S)\1*', section_end + 1, 1, 1 ) - 1,
         REGEXP_SUBSTR( line, '(\S)\1*', section_end + 1, 1, NULL, 1 )
  FROM   words
  WHERE  section_end > 0
)
SELECT id,
       line_no,
       section_start,
       section_end,
       section_value
FROM   words
WHERE  section_end > 0
ORDER BY id, line_no, section_start


ID
LINE_NO
SECTION_START
SECTION_END
SECTION_VALUE


1
2
1
28
A

1
2
31
34
B

1
2
39
63
C

1
3
1
3
D

1
3
4
4
E

1
3
7
14
F

1
3
19
27
G

1
3
43
50
H

1
3
55
61
I

1
4
1
2
J

1
4
9
11
K

1
4
12
14
L

1
4
22
23
M

1
4
25
26
N

1
4
57
61
O

1
5
13
13
P

1
5
60
61
Q

2
1
1
3
R

2
1
4
4
S

2
1
5
6
T

2
1
8
10
U

2
1
15
15
V

2
1
17
17
W

2
1
18
18
X

2
1
19
19
Y

2
1
20
20
Z

ID	LINE_NO	SECTION_START	SECTION_END	SECTION_VALUE
1	2	1	28	A
1	2	31	34	B
1	2	39	63	C
1	3	1	3	D
1	3	4	4	E
1	3	7	14	F
1	3	19	27	G
1	3	43	50	H
1	3	55	61	I
1	4	1	2	J
1	4	9	11	K
1	4	12	14	L
1	4	22	23	M
1	4	25	26	N
1	4	57	61	O
1	5	13	13	P
1	5	60	61	Q
2	1	1	3	R
2	1	4	4	S
2	1	5	6	T
2	1	8	10	U
2	1	15	15	V
2	1	17	17	W
2	1	18	18	X
2	1	19	19	Y
2	1	20	20	Z

ID	LINE_NO	SECTION_START	SECTION_END	SECTION_VALUE
1	2	1	28	A
1	2	31	34	B
1	2	39	63	C
1	3	1	3	D
1	3	4	4	E
1	3	7	14	F
1	3	19	27	G
1	3	43	50	H
1	3	55	61	I
1	4	1	2	J
1	4	9	11	K
1	4	12	14	L
1	4	22	23	M
1	4	25	26	N
1	4	57	61	O
1	5	13	13	P
1	5	60	61	Q
2	1	1	3	R
2	1	4	4	S
2	1	5	6	T
2	1	8	10	U
2	1	15	15	V
2	1	17	17	W
2	1	18	18	X
2	1	19	19	Y
2	1	20	20	Z

ID	LINE_NO	SECTION_START	SECTION_END	SECTION_VALUE
1	2	1	28	A
1	2	31	34	B
1	2	39	63	C
1	3	1	3	D
1	3	4	4	E
1	3	7	14	F
1	3	19	27	G
1	3	43	50	H
1	3	55	61	I
1	4	1	2	J
1	4	9	11	K
1	4	12	14	L
1	4	22	23	M
1	4	25	26	N
1	4	57	61	O
1	5	13	13	P
1	5	60	61	Q
2	1	1	3	R
2	1	4	4	S
2	1	5	6	T
2	1	8	10	U
2	1	15	15	V
2	1	17	17	W
2	1	18	18	X
2	1	19	19	Y
2	1	20	20	Z