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