SQL/XML - PowerPoint PPT Presentation

About This Presentation
Title:

SQL/XML

Description:

SQL/XML Releasing the data from RDBMS Examples from the article Generating XML from Relational Database Tables by Selim Mimaroglu in the September 2004 Web ... – PowerPoint PPT presentation

Number of Views:52
Avg rating:3.0/5.0
Slides: 5
Provided by: mm6
Category:
Tags: sql | xml

less

Transcript and Presenter's Notes

Title: SQL/XML


1
SQL/XML
  • Releasing the data from RDBMS
  • Examples from the article Generating XML from
    Relational Database Tables by Selim Mimaroglu in
    the September 2004 Web Services Journal

2
Consider a table of experts
  • Expert_id_prefix expert_id expert
  • EXP 3 Feynmann,
    R.P.
  • EXP 4 Stotler,
    Raymond
  • EXP 5 Gardner,
    Alfred
  • EXP 6 Upton,
    Steve
  • EXP 7
    McGuiness, Debra

3
Generating XML with SQL
Using Oracle SQLgt select XMLELEMENT(name,exper
t) from experts where expert_id
between 4 and 10 Using IBMs DB2 select
XML2CLOB(XMLELEMENT(NAME name,expert)) from
experts where expert_id between 4 and
10 Microsofts SQL Server 2000 supports the
same idea.
4
Producing
  • ltnamegtStotler, Raymondlt/namegt
  • ltnamegtGardner, Alfredlt/namegt
  • ltnamegtUpton, Stevelt/namegt
  • ltnamegtMcGuiness, Debralt/namegt
Write a Comment
User Comments (0)
About PowerShow.com