By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE table_name ( input ) AS
SELECT 'Record: 11, Entità : CustomerOrder, attributo: DESCRIPTION non conforme al formato atteso' FROM DUAL UNION ALL
SELECT 'Record: 3, Entità : CustomerOrder, attributo: DESCRIPTION non conforme al formato atteso' FROM DUAL;
2 rows affected
SELECT SUBSTR( input, INSTR( input, ',' ) + 2 ) AS output
FROM table_name;
OUTPUT |
---|
Entità : CustomerOrder, attributo: DESCRIPTION non conforme al formato atteso |
Entità : CustomerOrder, attributo: DESCRIPTION non conforme al formato atteso |