How to convert database table into xml file

Advertisement

Hi.
How to convert database table into XML file in Oracle HTML DB.
Please let me know.
Thanks.

Advertisement

This not really a specific APEX question... but I search the database forum and found this thread which I think will help
Exporting Oracle table to XML
If it does not I suggest looking at the database forum or have a look at this document on using the XML toolkit
http://download-east.oracle.com/docs/html/B12146_01/c_xml.htm
Hope this helps
Chris

November 30, -0001

How to convert database table into xml file

Hi. How to convert database table into XML file in Oracle HTML DB. Please let me know. Thanks.This not really a specific APEX question... but I search the database forum and found this thread which I think will help Exporting Oracle table to XML If i

How to convert alv list into excel file?

Hi Experts,         i have created one report for Due Date Analysis. Now My output is displaying in ALV list. But I need to convert the data which in alv list into Excel File. then only i have to send the Excel File to the Customer Thro Email.      S

How to convert Java string into XML one?

With SAX I can parse an xml file, but I should create xml file by hands. Ok, it's simple, but how to encode java string into XML constant like "Hello & goodby" into "Hello & goodby" ? Is there a standard method for such special

How to convert DOM Tree in XML File

Hi there, I am successful to build a DOM tree in memory where i am adding elements. Now after all this i want to make a XML file of that DOM representation. Now, i am confused with my code that how to transfer DOM structure to xml file ? A small code

How to convert ALV output into XML format.

Hi all, I just want to know how to convert an ALV output into a XML format, this is really urgent. regards, Ruchika sainiThis program exports an internal table to an XML file. *---- Report ZPRUEBA_MML_13 * Export an internal table to XML document * N

How should convert text file into XML file?

I do a project "WEB SERVER LOG ANALYZER" using JSP. For that i copy the content of log file into the other file . how i convert it into XML file . xplain with codingRead this [page.|http://www.devx.com/getHelpOn/10MinuteSolution/20356]Read other

Anyone know how to convert a 3D sphere .STL file into a .igs file?

Anyone know how to convert a 3D sphere .STL file into a .igs file?And for what? Why? This would be kinda atrocious and awful, but weird things happen... MyleniumRead other 2 answers

Conversion of inbound IDOC into XML file

Hi experts, We have an inbound idoc (FIDCC2) that starts and triggers the creation of an FI document. We would like now, that, instead of creating the FI document, the inbound IDOC creates an XML file on a given directory, with the contents of the id

Insert Encoding tag into xml file. ?xml version="1.0"?

I am using oracle 10g. I am using dbms_xmlgen.getxml function to generate xml data for oracle tables. I use utl_file to write data back into xml file. Oracle is generating the file in the following manner... <?xml version="1.0"?> <ROWSE

Why we need to conver Context  Node data into XML file----Export to Excel

Hi All, Let me clarify my dought........today i have gone through the concept of  "Exporting Context Data Using the Webdynpro Binary cache" in SAP Online Help. From the SAP Online Help pdf document, i have found that, the context node data has b

Import data from Oracle table into flat file

How to import the data in the oracle table into flat file using UTL File of PL/SQL.... I am new in PL/SQL.. can someone help me in writing query?Note : Not Tested. DECLARE V1 VARCHAR2(32767); F1 UTL_FILE.FILE_TYPE; cursor c1 is select ename,empno fro

How to add a table to pdf file ?

How to add a table to pdf file ? Not able to use the table component. Its not active. Any help pls Thanks Peter http://www.ethos.aghttp://forum.java.sun.com/faq.jsp#formatRead other 2 answers

Outbound oracle data into xml file

Hi Odie, Your previous inputs for xml inbound was working fine, in the similar way now I need outbound the oracle apps data into .xml file format. For that I've written one sample script like this. I thought of making use of the utl_file option in Or

Writing into XML File in Flex

Hi, I want to create a XML file (dynamically) and writes data into that xml file(data coming from web service). Thanks in advance.i want to write the data(coming from web service) into XML file and keep that XML file in Cache,then read that XML file

How to write a procedure to load the data into a table using xml file as input to the procedure?

Hi, Iam new to the xml, can u please anyone help me how to write procedure to load the data into a table using xml as input parameter to a procedure and xml file is as shown below which is input to me. <?xml version="1.0"?> <DiseaseCode

How to convert text file into xml file

Hi Folks, I am genarating list of data into text file, but i want to genarate xml file for this text file. How to achive this , please let me know. Thanks. regards Vishalhi Vishal,   Use<b> GUI_DOWNLOAD</b> FM and give the file name as <b&g

How to download internal table data into xml file?

Hi, Experts, I have downloaded internal table data into XLS format using GUI_DOWNLOAD Function module, But i didn't Know how to download internal table data into XML format please post some ideas/inputs on this issue. Thank you, Shabeer ahmed.check t

How to convert excel file into xml file

Friends Will you please help me out becz i am daily getting excel file from SAP which i have to translate into the xml file. Waiting for ur reply. HiteshDepends on how your excel document looks like and what you wish to accomplish. First, save the ex

How to convert .stl file into .xml file. Subtitles to IMPORT INTO FCPro

I have a subtitles file which was created in dvd studio pro. I exported that file and made a .stl file (which can be opened with TextEdit). I need to import that file into FCP to then make a quicktime file w/subs to be exported. I'm trying to use Tit

XML data into Oracle Tables. XML file on Application Server.Oracle Apps R12

Hi All, My Database version : 11.2.0.2.0 I have an XML file which needs to be loaded into the Database Tables. How ever i do not want to use the XMLTYPE as given below insert into test1 ( SELECT PrcDate, PmtType, PmtStatus, PmtTypeCount, PmtTypeAmt F