JSON value from a clob field
Select JSON value from a CLOB field The header_info field { "Message-ID":"<SJ0P105MB0345C789105MB0345.MAMP999.PROD.LOOKIT.COM>" } I tried select JSON_VALUE('{header_info}', '$.Message-ID') from epres.mydata I need to select the "Message-ID" I get an error ORA-40597: JSON path expression syntax error ('$.Message-ID') JZN-00209: Unexpected characters…