XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » Stylus Studio Code Samples & Utilities » Loading data in XML file/document in an Oracle relational table.
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
+ Stylus Studio Technical Forum (14621)
+ Website Feedback (249)
+ XSLT Help and Discussion (7625)
+ XQuery Help and Discussion (2016)
+ Stylus Studio FAQs (159)
- Stylus Studio Code Samples & Utilities (364)
-> + XSL in HTML? (9)
-> + Help Creating a new wsdl (2)
-> + Extracting XML from a database... (6)
-> + Stylus Studio Converters comma... (18)
-> - Schema for RDF section within ... (1)
-> + Text to XML converter not in t... (4)
-> + Filtering data with a combo bo... (2)
-> - Loading data in XML file/docum... (2)
-> ->Loading data in XML file/...
-> + Stylus StudioŽ's Web Service C... (2)
-> - How to replace a specific node... (1)
-> + xsl:result-document and multip... (2)
-> - Russian Doll Schema (1)
-> + Populating MS access from XML ... (9)
-> + xsd to xml (5)
-> + populating treeview control wi... (6)
-> + Problem generating a simple DT... (4)
-> + XML Newbie Basics (4)
-> + How do I ... Build an HTML Pag... (2)
-> + .NET API (6)
-> - Building Your Own Search Engin... (1)
-- Previous [61-80] [81-100] [101-120] Next
+ Stylus Studio Announcements (113)
Topic  
Postnext
Ajit ChhinaSubject: Loading data in XML file/document in an Oracle relational table.
Author: Ajit Chhina
Date: 22 Aug 2006 01:52 PM
Hello,
I am absolutely new to XML. I have a work at hand. I have an XML document, which is generated by the application. The requirement is to extract the data from the XML file/document and load it in the Oracle database in a relational table.

I need to know, firstly, is there any functionality in Stylus Studio to accomplish this task. Secondly, is there any other method to do this task. This has to be automated, as the files come in, the taskshould be done automatically.

Any input or advice is apprecaited.

Thanks,

Ajit
Posttop
Ivan PedruzziSubject: Loading data in XML file/document in an Oracle relational table.
Author: Ivan Pedruzzi
Date: 22 Aug 2006 06:05 PM
Ajit,

Please have a look to SQL/XML support in Stylus Studio

Chapter 12 "Accessing Relational Data as XML"
http://www.stylusstudio.com/docs/v2006R3/d_rdb.html

Video tutorial
http://www.stylusstudio.com/videos/dbtoxml2/dbtoxml2.html

Hope this helps
Ivan Pedruzzi
Stylus Studio Team
   
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.