hrs Specialised Training to meet your needs

Home Up The Team Public Courses Customised Consultancy

xml

                         

Introduction to using XML with Oracle 8i/9i

Assumptions and pre-requisites

Delegates are programmers with some experience of PL/SQL and/or Java programming in Oracle 8/8i/9i.

Course Outline

What is XML?

  • Why it was evolved from HTML
  • B2B
  • Transformations using XSL stylesheets
  • Oracle's XML Components
  • Generating XML from the SQL line
    • DBMS_XMLGEN
    • SYS_XMLGEN
    • SYS_XMLAGG

Generating and reading XML using XSU and PL/SQL

  • Using the basic XMLGEN package
  • Using DBMS_XMLQuery and DBMS_XMLSave

Generating and reading XML using XSU and Java

  • Using OracleXMLQuery and OracleXMLSave
  • Using JDBC Resultsets
  • Using REF CURSORs
  • Using SQLJ iterators

Using DOM and XPath with PL/SQL

  • Using the packages XMLDOM, XMLPARSER, and XSLPROCESSOR

Using DOM and XPath with Java

  • Using DOMParser

Using SAX with Java

  • Using callbacks
  • Using SAXParser

Validation techniques

  • DTD
  • Schema

Namespaces

  • Why are Namespaces required?
  • Considering the different standards
  • Revisiting the previous code to use Namespaces

Using interMedia Text

  • Basic Oracle Text on the SQL line
  • Using CONTAINS and indexes
  • Searching using PL/SQL
  • Searching using Java

An introduction to JDeveloper 9i

  • Overview of the product
  • Creating a workspace, project, and application files
  • Using JDeveloper for PL/SQL development
  • Using JDeveloper for Java development
  • Rewriting previous code within JDeveloper
[RETURN TO LIST OF COURSES]

 

[Home] 

Send mail to pleasering@oracle-training.co.uk with questions or comments about this web site.
Copyright © 2003 hrs
Last modified: February 11, 2003