clear markdown feedback
clear markdown feedback
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 3798898 fiddles created (41836 in the last week).

select version();
version()
8.0.22
version()
8.0.22
 hidden batch(es)


CREATE TABLE BUCHUNGEN( BUCHUNGSTEXT varchar(30) )
 hidden batch(es)


INSERT INTO BUCHUNGEN(BUCHUNGSTEXT) VALUES('RE12342020 Karl Mustermann'); INSERT INTO BUCHUNGEN(BUCHUNGSTEXT) VALUES('RE45672020 Grete Beispiel');
 hidden batch(es)


SELECT REGEXP_SUBSTR(t.BUCHUNGSTEXT, 'RE[0-9]+') AS BELEGFELD, BUCHUNGSTEXT FROM BUCHUNGEN t
BELEGFELD BUCHUNGSTEXT
RE12342020 RE12342020 Karl Mustermann
RE45672020 RE45672020 Grete Beispiel
BELEGFELD BUCHUNGSTEXT
RE12342020 RE12342020 Karl Mustermann
RE45672020 RE45672020 Grete Beispiel
 hidden batch(es)