Transcription of SQL/XML for Developers - Database Wisdom
{{id}} {{{paragraph}}}
SQL/XML for Developers Lewis Cunningham Data Architect, JP Morgan Chase ODTUG Kaleidoscope 2009 06/21/2009 Introduction Oracle ACE Director Author Data Architect for JP Morgan Chase Twitter: @oracle_ace Blogger An Expert's Guide to Oracle Technology The Database Geek Cloud Computing Info SQL/XML for Developers Agenda What is XML? What is the XMLType data type? What is SQL/XML ? What should(n t) I do with XML? 3 What is XML? <?XML?> 4 What is XML? Semi-Structured Hierarchical Not relational Not freeform Markup Language Tags Identify Data <NAME>Lewis</NAME> Human AND machine readable 5 What is XML? Elements Root Element Child Elements Elements are nodes Some nodes contain elements Some nodes contain character data A node can contain both Namespaces 6 What is XML? Well Formed XML Follows XML formatting rules All open tags have closing tags All attribute values are enclosed in quotes If a document is not well formed, it is not XML A well formed document may not be a VALID document Valid XML Conforms to a specific specification (DTD, XSD, RNG) A valid document will always be a well formed document 7 What is XML?
SQL/XML for Developers Agenda What is XML? What is the XMLType data type? What is SQL/XML? What should(n’t) I do with XML? 3
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
{{id}} {{{paragraph}}}