How to create xml file from relational tables in 10gR2

Advertisement

Hi,
I am very new to XML and was wondering how to create an XML file from querying relational tables. Some child tables may contain multiple rows that need to be returned in certain instances. Other queries will just be single or multiple rows from one or more tables. I would like to use the latest feathers in 10gR2. Thanks for any help you can provide.
Thanks,
Lee

Advertisement

Here is the first row of data created from our person table - it used the column names as the tag names:
<?xml version="1.0"?>
<ROWSET>
     <ROW>
          <MP_ID_SEQ>289</MP_ID_SEQ>
          <MP_NAME>LOBERG,JUDITH LEE</MP_NAME>
          <MP_SEX>F</MP_SEX>
          <MP_RACE>I</MP_RACE>
          <MP_DOB>19500709</MP_DOB>
          <MP_HT>504</MP_HT>
          <MP_WT>170</MP_WT>
          <MP_EYE_CLR>BLU</MP_EYE_CLR>
          <MP_HAIR_CLR>BRO</MP_HAIR_CLR>
          <MP_SKN>RUD</MP_SKN>
          <MP_SMT>POCKMARKS</MP_SMT>
          <MP_SOC>517607968</MP_SOC>
          <MP_OLN>517607968</MP_OLN>
          <MP_OLS>MT</MP_OLS>
          <MP_OLY>2007</MP_OLY>
          <MP_CAUT_MED>70</MP_CAUT_MED>
          <MP_VISION_SCRIPT>C0RRECTIVE LENSES</MP_VISION_SCRIPT>
          <MP_DNA_AVAIL>N</MP_DNA_AVAIL>
          <CREATED_BY>MMPS</CREATED_BY>
          <DTM_CREATED>31-AUG-06</DTM_CREATED>
          <MI_INC_ID_SEQ>288</MI_INC_ID_SEQ>
          <MP_ALERT>N</MP_ALERT>
     </ROW>

October 11, 2015

How to create xml file from relational tables in 10gR2

Hi, I am very new to XML and was wondering how to create an XML file from querying relational tables. Some child tables may contain multiple rows that need to be returned in certain instances. Other queries will just be single or multiple rows from o

How to create xml file from original

I have this complicated xml and I want to search through it and make a new xml with only element I find that match. what is the best way to do this? the file is about 6mb and I want to read the whole file easily..should i load to database table and c

Please Help. Trying to create XML file from 2 tables.

Step1: Target XML format Created an XML <DEPART> <DEPARTMENT_ID>10</DEPARTMENT_ID> <DEPARTMENT_NAME>Administration</DEPARTMENT_NAME> <MANAGER_ID>200</MANAGER_ID> <LOCATION_ID>1700</LOCATION_ID> <EMP

Create XML file from table data

Dear All, with dataservice 4.0, I want to create an XML file from a table data. Table have a single column but more record, for example: 0001000488;100;EUR; 0001000489;200;EUR; 0001000450;300;EUR; My desired XML output: <Data>   0001000488;100;GBP;

How to Download XML File to internal table

Hi Friends, This is my urgent requirement. How to download XML File to Internal table. regards pauldharmaHai, Please check this Link http://www.sap-img.com/abap/upload-direct-excel.htm PARAMETERS: filename LIKE rlgrap-filename MEMORY ID M01,         

Create XML File from a specified XSD file

Hi, I'd like to create an XML document with java. BUT How can we "bind" this creation with a XSD file. Hence, the creation may fail if the XSD binded file is not respected. So I know how to create XML file but not bind to this creation my proper

Create XML file from XSD

Hello, can anybody help me with generating an empty tagged XML file from a XSD file. Any sample java code will be highly appreciated. Thanx in advance. A .Apache XML Beans presents a way to compile the XSD Schema and generate Java classes for each el

How to Generate XML File from Java Code.

I want to generate the xml file from the java code. Could you plz suggest any webSite address with example?Here is the code import java.io.File; import javax.xml.parsers.DocumentBuilder; import javax.xml.parsers.DocumentBuilderFactory; import javax.x

How to update XML file from the program

i am new in abap , and i have the following issue,so plz anyone who knows how to do it Background : An XML file is used as the datasource for a Flex Application. From time to time this requires updating with new staff details. i have already saved th

Create XML file from SQL trigger

I have to create a XML file of a record when a certain column of table Absences is updated. I have the following bcp command in the (after update) trigger :     bcp "select absences.HID, absences.Amount,absences.Itemcode,absences.Itemcount, absences.

How to Create XML Schema From JTree ?

Please help me... Thank you. This is Code Tree.java ----- Run This File import java.awt.BorderLayout; import java.awt.Dimension; import java.awt.GridLayout; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import javax.swing.J

Problem in Creating excel file from internal table

Hi Experts,             here iam having a proble with creating an excel file from an internal table which is having around 15 records, when iam generating an excel file, its getting only upto 255 chars, after that its breaking and new record is being

Create .xml file from a java file

I wanted to know how can we create a .xml file through java with the given data. For example: book saler. data given through java are 1)Sl no 2)Book name 3Book type 4)Book price i want a xml file generated through the java code can anyone help me out

How to Create PDF files from XSL-Fo

Hi all, I have in my KM content many XML files, and I want to export the content to PDF. Hi have the XSLT file, but some one could help me how to integrate this with FOP? Thank youHi Joao,                 Verify these links hope it may helps... http:

How to create MUSE file from existing MUSE site?

Hi- A customer has a site that was created with MUSE and she wants some edits made to it. I have installed MUSE and can access the server via FTP. I've downloaded the site's html files and assets, but these are useless in MUSE. How do I create or get

How to create .csv file from ABAP report

Hi We have a requirement to generate .csv file from abap report. Currently user saves data from abap report to spreadsheet(.xls format) in desktop.  Then opens excel file and save as .csv format.  Need option to save directly in .csv format instead o

Create XML file from java

Hi all i am working to create a XML file using java can any one show me some sample code how to do soAll I suggested was to insert a single line ("X.serialize(root);") into your code. Anyway, here's a ready-to-compile source code based on yours.

How to generate xml file from an array of data using jQuery

Hi All, Iam facing the problem with diaplaying array of data into a xml file, Actually iam using SAPUI5 commons table to display the backend data, each row in the table has checkbox. If we select each checkbox, iam getting the particular record and p

Creating XML files from one data file in a java program

<statement>      <name>John Dow </name>      <address>123 Main</address>      <phone>972-213-3434</phone> </statement> <statement>      <name>Jane Dow </name>      <address>345 Main&l

Creating an XML file from multiple sql tables

I have very little xml experience, but need to generate an xml file from multiple table. I know what the output needs to look like, but do not know how to setup the code. Any help would be appreciated. - <Practice SourceID="EPIC" ExternalPrac