How to extract data from an xmltype column
Summary:
How to extract data from an xmltype column that is in the table ZX_CONDITIONS
Content (please ensure you mask any confidential information):
I am trying to put in place a datamodel that reads off the ZX_CONDITIONS table. I need to have the columns CONDITION_GROUP_CODE and the <value> that lies within the XMLTYPE coumn .FLEX_FILTER_VALUE. How do I write the sql statement that will pull out these two columns
Version (include the version you are using, if applicable):
Oracle Fusion Cloud Application 23C (11.13.23.07.0)
Code Snippet (add any code snippets that support your topic, if applicable):
Tagged:
0