XML Database (MOSC)

MOSC Banner

How to generate XSD file (XML Schmema defination file) from SQLX Query

edited Aug 27, 2012 8:32AM in XML Database (MOSC) 9 commentsAnswered
Hello -

I've following SQLX query that we use to generate XML document, but our external systems wants xml schema definition (xsd) as well.

How can we do that?

Appreciate any help

  SELECT
   XMLElement ("Maharaj",
    XMLAGG(
          XMLELEMENT ("Employee",
         /* XMLAttributes('http://www.oracle.com/emp_simple.xsd' AS "xmlns",
                    'http://www.w3.org/2001/XMLSchema-instance' AS "xmlns:xsi",
                    'http://www.oracle.com/emp_simple.xsd
                     http://www.oracle.com/emp_simple.xsd'
                       AS "xsi:schemaLocation"),*/
      XMLForest(e.employee_id     AS "EmployeeId",
                e.last_name       AS "Name",
                e.job_id          AS "Job",
                e.manager_id      AS "Manager",
                e.hire_date       AS "HireDate",

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center