oracle en xml
Download
Skip this Video
Download Presentation
Oracle en XML

Loading in 2 Seconds...

play fullscreen
1 / 10

Oracle en XML - PowerPoint PPT Presentation


  • 80 Views
  • Uploaded on

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,

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Oracle en XML' - norm


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
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
ad