Stack Overflow
Stack Overflow

Questions tagged [oracle-xml-db]

Oracle XML DB is a native XML storage and retrieval technology that is delivered as a part of all versions of Oracle Database.

Oracle XML DB is a native XML storage and retrieval technology that is delivered as a part of all versions of Oracle Database.

Oracle XML DB provides full support for all of the key XML standards and supports native XML application development: application developers are able to use XML-centric techniques to store, manage, organize, and manipulate XML content stored in the database.

Oracle XML DB also supports the SQL/XML standard, which allows SQL-centric development techniques to be used to publish XML directly from relational data stored in Oracle Database 12c.

52 questions
6
votes
2 answers

How to store XML data into Oracle tables

In our business, we receive and need to process thousands of XML files per day and all these files are in the same format. We would like to store these data into oracle tables and reserve the hierarchical relationship of these data and then we can…
user981848
  • 295
  • 2
  • 4
  • 14
4
votes
3 answers

Oracle XMLTable- fetching column from parent node

I have the following XML structure: 1 10000 11 1000 …
Rachcha
  • 8,486
  • 8
  • 48
  • 70
4
votes
2 answers

Oracle SQL extractvalue from multiple elements

I have spent days looking for a simple solution to the following problem and I need some help please. I have a Oracle table with two columns, recid (Account Number) as the primary key and xmlrecord which stores all the xml data. I am trying to…
Mark
  • 61
  • 1
  • 4
4
votes
1 answer

Oracle xmltype column indexing based on xml attribute

I am using structured storage type for xmltype column. I am trying to create an index on the attribute but somehow Oracle is not taking the index and doing a full table scan. I have checked the documentation at…
Kevin Parker
  • 55
  • 1
  • 3
2
votes
3 answers

What is Oracle Native web services?

Native web services is a new feature of the XML DB technology. In google i found that it`s very close to SOA. Can anyone simply explain: 1) what is the main usage of Native web services 2) what is the main difference of XML DB 11g and previous XML…
drnk
  • 764
  • 2
  • 9
  • 18
2
votes
3 answers

Oracle - validate date format (yyyy-mm-ddThh24:mi:ssZ) in XML against XSD

Oracle version: The result of this query select * from v$version; is: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production PL/SQL Release 11.2.0.4.0 - Production "CORE 11.2.0.4.0 Production" TNS for Linux: Version…
VBoka
  • 8,995
  • 3
  • 16
  • 24
2
votes
0 answers

Oracle SQL Function XMLISVALID returns allways 0

knows someone why this statement delivers me the result 0 and not 1 SELECT XMLISVALID( XMLType(' 10.06.03 13.06.03 …
Michael
  • 81
  • 1
  • 4
2
votes
1 answer

LEFT OUTER JOIN with XMLTABLE doesn't work?

Here is the sample query- WITH empdata AS (SELECT xmltype (' 1 Abraham …
Rachcha
  • 8,486
  • 8
  • 48
  • 70
2
votes
3 answers

Extract specific xml node from duplicate ones in oracle

Given is the value of "my_xml" column in "XYZ" table ADI Ahmedabad GNR Gandhinagar …
Not a bug
  • 4,286
  • 2
  • 40
  • 80
2
votes
1 answer

Oracle DB, validate xml during insert

I'm trying to validate a document XML during it's inserting into a table in ORACLE database. I've define a XML Schema and a XMLTYPE with this schema in my table but the db allow me to insert a wrong xml. My…
Mark116
  • 653
  • 1
  • 6
  • 23
2
votes
1 answer

Inserting new tag in XML in xmlDB

Is it possible to insert new tag in the XML which is there in the XML-database? For example; below is my example which is exists in the database:
Ramesh
  • 340
  • 1
  • 7
  • 21
2
votes
2 answers

Comparing dates in Oracle XQuery (XMLQuery/XMLTable)

While trying to implement some checks in Oracle database with use of XQuery I need to compare if two dates are the same, but can't do that on obvious manner because casting to xs:date don't really remove time part of value from xs:dateTime. Query…
ThinkJet
  • 6,725
  • 24
  • 33
2
votes
1 answer

ORA-00937: not a single group function (XMLAGG)

I used the XMLAGG aggregate function in a single row and I keep getting the error code ORA-00937. Why? The structure for the report is: 2015 September 2015-09-22
A1
…
Caramel2017
  • 23
  • 3
2
votes
2 answers

Reading XML element occurrences using PL SQL

I have this XML. b1 c1 b2 c2 I want to be able to extract the values of elements 'b' and 'c' using PL\SQL. I'm using Oracle 10g. So far I have this, SELECT XML.b ,…
GoAlves
  • 435
  • 3
  • 5
  • 16
2
votes
1 answer

Parse XML in oracle when same dom structure is repeated multiple time's

I know how to parse an xml in oracle which goes something like this select extractvalue(column_value, 'CIRS/CIR/@applicantId') applicantId into applicantId from CIBIL_BINARY_INPUT ,table(xmlsequence(xmltype(ded_enq_xml))) Now i have an xml as…
Mohit Tamrakar
  • 395
  • 1
  • 4
  • 7
1
2 3 4