Unable to retrieve columns from the CLOB datatype
Hi All,
In the custom table, we have several columns. One of these columns is a CLOB type that contains multiple fields in XML format. We are attempting to retrieve these fields using the XMLTABLE function, but the query is not returning the correct data. I have attached a sample of the CLOB column data in XML format.
Could you please review and share inputs on where the syntax might be incorrect, and how to properly extract the required fields.
select source_id,xt.*
from xx_file_details fd
, xmltable('/TEST_WORKER/PERSON_DETAILS/PERSON_REC'
passing XMLTYPE(fd.FILE_CLOB)