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)