---
title: "Discussion on \"XML Insights with Oracle\" | Hashnode"
description: "Discussion on \"XML Insights with Oracle\". 1) XML in Oracle SQL (XML to table)\nKey Data Types & Functions\n\nXMLTYPE: Native type to store and query XML.\n\nXPath/XQuery via:\n\nXMLTABLE (preferred for shredding XML into rows/columns),\n\nXMLQUERY, XMLCAST,\n\nLegacy EXTRACT() / EXTRACTVALUE() (depreca..."
url: "https://hashnode.com/posts/xml-insights-with-oracle/69709599667e8115879c0d61"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [XML Insights with Oracle](https://xml-insights-with-oracle.hashnode.dev/xml-insights-with-oracle?utm_source=hashnode&utm_medium=feed)

1) XML in Oracle SQL (XML to table) Key Data Types & Functions XMLTYPE: Native type to store and query XML. XPath/XQuery via: XMLTABLE (preferred for shredding XML into rows/columns), XMLQUERY, XMLCAST, Legacy EXTRACT() / EXTRACTVALUE() (depreca...

Jan 21 · 8 min read · xml-insights-with-oracle.hashnode.dev  
Read the article

-   [#oracle-apex](https://hashnode.com/tag/oracle-apex)
-   [#xml-parsing](https://hashnode.com/tag/xml-parsing)
-   [#oracle-sql](https://hashnode.com/tag/oracle-sql)

## Written by

[Chetana Suresh Apraj](https://hashnode.com/@chetana167)

@chetana167

  
[View profile](https://hashnode.com/@chetana167)

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
