Question: what is xmltable in oracle?
Answer: XMLTABLE : Convert XML Data into Rows and Columns using SQL. ... Oracle 10g Release 2 introduced the XMLTABLE operator, which allows you to project columns on to XML data in an XMLTYPE , making it possible to query the data directly from SQL as if it were relational data.