XML Database (MOSC)

MOSC Banner

query registered xmlschema xmltype data

edited Jan 14, 2010 4:16AM in XML Database (MOSC) 1 commentAnswered
I am new to xml db and   having problem extracting the data from xmltype column:

I did the following steps

1. Create XML SCHEMA

BEGIN -- Delete the schema, if it already exists; otherwise, this produces an error. -- Delete the schema, if it already exists; otherwise, this produces an error. DBMS_XMLSCHEMA.deleteSchema ( ( 'http://www.example.com/schemas/parameter.xsd', 'http://www.example.com/schemas/parameter.xsd', 4 4 ); END; /

); END; / BEGIN -- Register the schema -- Register the schema DBMS_XMLSCHEMA.registerSchema ( ( 'http://www.example.com/schemas/parameter.xsd', 'http://www.example.com/schemas/parameter.xsd', '<schema targetNamespace="http://www.example.com/IPO

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