Current Position:Home > How to create a relational view base on an xmltype table which included sev

How to create a relational view base on an xmltype table which included sev

Update:10-11Source: network consolidation
Advertisement
Hi,
I am using oracle 11.2.0.1.0.
how to create a relational view base on an xmltype table which content several different .xml files?
Thanks.
for examle:
SQL> SELECT OBJECT_VALUE FROM document;
Edited by: Cow on Jan 6, 2011 7:57 PM

The Best Answer

Advertisement
For example I already have these three xml files inserted into the document xmltype table.
These xml files have same schemas. I have attached below.
I want to show all elements/attribute values in xml files to relational view.
Is this possible to create one big relational view to show everything
or I have to create three separate relation views then use UNION to put together? Thanks a lot. Cow
<?xml version="1.0" encoding="UTF-8"?><?xml-stylesheet href="http://www.accessdata.fda.gov/spl/stylesheet/spl.xsl" type="text/xsl"?>
<document xmlns="urn:hl7-org:v3" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="urn:hl7-org:v3 http://localhost:8080/home/DEV/xsd/spl.xsd">
<id root="5ca4e3cb-7298-4948-8cc2-58e71ad32694"/>
</component>
</document>
<?xml version="1.0" encoding="UTF-8"?><?xml-stylesheet href="http://www.accessdata.fda.gov/spl/stylesheet/spl.xsl" type="text/xsl"?>
<document xmlns="urn:hl7-org:v3" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="urn:hl7-org:v3 http://localhost:8080/home/DEV/xsd/spl.xsd">
</component>
</document>
Edited by: Cow on Jan 4, 2011 9:51 AM
  • How to create a relational view base on an xmltype table which included sev Update:10-11

    Hi, I am using oracle 11.2.0.1.0. how to create a relational view base on an xmltype table which content several different .xml files? Thanks. for examle: SQL> SELECT OBJECT_VALUE FROM document; Edited by: Cow on Jan 6, 2011 7:57 PMFor example I alre

  • Creating a combined view of two spatially indexed tables Update:10-11

    Hi All, I'm using oracle 10g and C++ occi to store and retrieve data. I have two tables that are identical in structure, they have an SDO_GEOM column where I store lat/long/altitude info. When I store the data using a stored procedure, the data is pu

  • Insert XML file into Relational database model without using XMLTYPE tables Update:10-11

    Dear all, How can I store a known complex XML file into an existing relational database WITHOUT using xmltypes in the database ? I read the article on DBMS_XMLSTORE. DBMS_XMLSTORE indeed partially bridges the gap between XML and RDBMS to a certain ex

  • Creating MS- Access data base from the Internal tables data of an ABAP Prog Update:10-11

    Hi, I have a requirement where I have to create Access tables from the Internal tables of ABAP program. The tables are like Project systems Header data, WBS elements data, Netwrok data, Activity data, Milestone data and Project revunes. I will have t

  • How to create index to speed up query on XMLTYPE table Update:11-30

    I have a table of XMLTYPE called gary_pass_xml. What kind of index can I create on the table to speed up this query. SELECT (Extract(Value(FareGroupNodes),'/FareGroup')) FareGroup FROM GARY_PASS_XML tx, TABLE(XMLSequence(Extract(Value(tx),'/FareSearc

  • Create Relational View got error: ORA-19276: XPST0005 - XPath step specifie Update:11-30

    Hi expert, I am using Oracle 11.2.0.1.0 XML DB. I am successfully registered schema and generated a table DOCUMENT. I have succfully inserted 12 .xml files to this table. SQL> SELECT OBJECT_VALUE FROM document; OBJECT_VALUE <?xml version="1.0&q

  • Create Relational View in AW Update:11-30

    Hi Everyone, I am currently trying to create a relational view in the awm to use in the administration tool in BIEE. However, everytime i click on the plug in- create relational view all my dimension is greyed out except measures. and when i click on

  • BIEE ERROR when creating Relational View Update:11-30

    Hi Everyone, I am using the OTN Relational View Creator from the oracle website to create my relational views. However, all my dimension are grayed out and i am unable to select my attributes and hierarchies. Would anyone know what I am doing wrong o

  • AWM Create Relational View for BIEE Update:11-30

    Hi Sir/Madam, I am having trouble trying to create my relation view in the analytical workspace manager. Every time I try and create it, it gives me all this error. The error is as follow; ####ERROR LOG##### APR-24-2008 03:49:33: ** APR-24-2008 03:49

  • Convert XML to relational view Update:11-30

    WE are retrieving data using Web Services, i.e. using SOAP protocol and receiving data in XML format. We need to access this data using a normal relational view, but can not find a solution how to do this. Example: The returned XML is a invoice with