DBAzine.com

Sections

Personal tools

You are not logged in
Log in
Join

You are here: Home » 10g » Oracle10g Articles » Storing XML Data » Mapping of elements attributes

Who Are You?

I am a:
[ Results | Polls ]
Votes : 2659

Comment

Above in this comment thread: Storing XML Data

Mapping of elements attributes

Posted by elisabetta at 2005-05-02 08:41 AM

Could you please explain how to map and store attributes such as "num" to a column of a relational table?

Thanks

Mapping of elements att

Posted by mscardina at 2005-05-16 10:07 AM

How this is done is dependent on the database you are using and the underlying schema. If you are using an Oracle DB this can be done through Java (oracle.xml.sql.dml) or PL/SQL (DBMS_XMLSave) with the XML-SQL utility that comes with the Oracle XDK that ships with the DB or is available on OTN at http://otn.oracle.com/tech/xml. This mapping is done automatically for you based upon the attribute-column name mapping.

Transaction Management
Reduce downtime and increase repeat sales by improving end-user experience.
Free White Paper

Database Recovery
Feeling the increased demands on data protection and storage requirements?
Download Free Report!