id number(1),

text varchar(2000)

);

insert into test_txt values(1,'BRUG HIDDEN 4. The student is obliged to justify the absence from educational classes within the specified period:

6)xfasdfkjasdgkdsethkgjaskgjbsajgbkjsdguihifafa');

insert into test_txt values(2,'BRUG HIDDEN 4. The student is obliged to justify the absence from educational classes within the specified period:

6)xfasdfkjasdgkdsethkgjaskgjbsajgbkjsdguihifafa');

insert into test_txt values(3,'BRUG HIDDEN 4. The student is obliged to justify the absence from educational classes within the specified period:

6)xfasdfkjasdgkdsethkgjaskgjbsajgbkjsdguihifafa');

insert into test_txt values(4,'BRUG HIDDEN 4. The student is obliged to justify the absence from educational classes within the specified period:

1) parents or legal guardians excuse the student''s absence by the end of the second week of the following month / for the previous month / in justified cases (e.g. a visit to a doctor), the parent or legal guardian may exempt some classes in person or in writing;

2) in the event of a student''s resignation from participation in non-compulsory classes, written information from the parent or legal guardian is required;

3) expected absence of a student for more than one week (e.g. stay in a sanatorium, hospital, chronic disease), parents or legal guardians are obliged to notify the class teacher within 3 days;

4) if the absence is not excused within the prescribed period, the class teacher explains the reasons for the absence with the parents or legal guardians;

5) information about frequent absenteeism of students is passed to the school pedagogue, parents are called

6)xfasdfkjasdgkdsethkgjaskgjbsajgbkjsdguihifafa');

insert into test_txt values(5,'BRUG HIDDEN 4. The student is obliged to justify the absence from educational classes within the specified period:

1) parents or legal guardians excuse the student''s absence by the end of the second week of the following month / for the previous month / in justified cases (e.g. a visit to a doctor), the parent or legal guardian may exempt some classes in person or in writing;

LENGTH( text ) AS text_len,

match_num,

SUM( LENGTH( text ) ) OVER ( PARTITION BY match_num ) AS total_len

FROM test_txt

MATCH_RECOGNIZE(

ORDER BY id

MEASURES

MATCH_NUMBER() - 1 AS match_num

ALL ROWS PER MATCH

PATTERN ( a+ )

DEFINE

A AS SUM( LENGTH( text )) <= 3000

)