Oracle en xml
This presentation is the property of its rightful owner.
Sponsored Links
1 / 10

Oracle en XML PowerPoint PPT Presentation


  • 59 Views
  • Uploaded on
  • Presentation posted in: General

Oracle en XML. xml in database. Datatype XMLTYPE h ét xml datatype in de database CLOB, varchar2 ... Opslag XMLType (Object)tabel XMLType kolom anders (clob). XML Schema. dbms_xmlschema.registerschema db datatype annotaties procedure registerSchema(schemaURL IN varchar2,

Download Presentation

Oracle en XML

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Oracle en xml

Oracle en XML


Xml in database

xml in database

Datatype

  • XMLTYPE

    • hét xml datatype in de database

  • CLOB, varchar2 ...

    Opslag

  • XMLType (Object)tabel

  • XMLType kolom

  • anders (clob) ...


Xml schema

XML Schema

  • dbms_xmlschema.registerschema

  • db datatype annotaties

    procedure registerSchema(schemaURL IN varchar2,

    schemaDoc IN VARCHAR2,

    local IN BOOLEAN := TRUE,

    genTypes IN BOOLEAN := TRUE,

    genbean IN BOOLEAN := FALSE,

    genTables IN BOOLEAN := TRUE,

    force IN BOOLEAN := FALSE,

    owner IN VARCHAR2 := '',

    enableHierarchy IN pls_integer :=


Generatie

Generatie

  • dbms_xmlgen

  • ansi xml 2003 -> sqlxml

  • xmltype.createxml (clob, bfile, string)

  • demo -> sqlxml.sql


Extractie

Extractie

  • plsql

  • sqlxml - xmltype.extract...

  • dbms_xmldom

  • demo : xmlplsql.sql


Toegang

Toegang

  • sql (jdbc)

  • ftp

  • http

    • webdav

  • demo

    • explorer

    • IE

    • xmlspy?


Architectuur opties

Architectuur opties

xmlview

view

sqlxml

sqlxml

tabel

xmltabel


Samenvatting

Samenvatting

  • Erg uitgebreide ondersteuning voor XML in de database

    • De mogelijkheden nemen per versie toe.

    • 9iR2 biedt al heel veel

  • Echter... door de bomen is het bos soms niet meer te zien

  • XML als data of XML als Document

  • Vuistregels:

    • xmltype

    • sqlxml

    • schema based


Resources

Resources

  • OTN

    • http://www.oracle.com/technology/tech/xml/xmldb/index.html

  • Downloadable Oracle XDB demo

  • http://www.w3schools.com


  • Login