Stack Overflow
Stack Overflow

Questions tagged [xmltable]

XMLTable maps the result of an XQuery evaluation into relational rows and columns. You can query the result returned by the function as a virtual relational table using SQL. This tag can also be used to indicate tabular data shown in XML notation.

XMLTable maps the result of an XQuery evaluation into relational rows and columns. You can query the result returned by the function as a virtual relational table using SQL. This tag can also be used to indicate tabular data shown in XML notation.

283 questions
0
votes
1 answer

How to "Look ahead" in XSL to get table columns headers?

I have a XML structure like the following:
Rick Parker
  • 15
  • 2
  • 6
-1
votes
1 answer

Read Columns from XMLTable

I have the below xml in a column as CLOB. How to read the columns of the below XML using XMLTable. I need to retrieve the data for all the nodes. I have shown the nodes in the below. …
Buddy26
  • 39
  • 1
  • 6
-1
votes
1 answer

How to read multiple tags with same name in xml file using oracle xmltable

data YES
1
2
3
…
Wera
  • 13
  • 5
-1
votes
2 answers

Oracle XMLTABLE Function. How to merge nodes that have the same name?

The Post was Edited to provide a minimal reproducible example I'm looking for a way to concatenate all name nodes(could be 2-3-4 etc) together with space between them. The following example gives error ORA-19279: XPTY0004 - XQuery dynamic type…
Sss
  • 49
  • 7
-1
votes
1 answer

Oracle XmlTable performance

Oracle version 11.2.0.3.0 XML content is fetched as xmltype from CLOB field. It could be 1Mb or more. Below is an example of XML Im processing using XmlTable DDD DDD …
Lagi
  • 495
  • 4
  • 12
-1
votes
1 answer

reading XMLTYPE using XMLTable

Ok, so i have a problem in PLSQL that query returns literally 0 rows: select xt.CRN from xml_table x, XMLTable('/IE599/PotwierdzenieWywozu' passing x.xml_value columns CRN varchar2(100) PATH '@CRN' ) xt where x.id_xml=19740 Xml looks…
Bartosz Olchowik
  • 1,129
  • 8
  • 22
-1
votes
1 answer

XSLT: Using one Key to cross reference a second key

I need to transform XML into a Table Grid which takes the format: A1,B1,C1 A2,B2,C2 A3,B3,C3 The XML that I am working with provides one cell value per record, but each record supplies a DayOfWeek (column) and Stream(Row) value. I have made a…
iainc
  • 862
  • 6
  • 20
-1
votes
2 answers

How to insert xml data into sql

Final Fuel Tax Rates 1Q2010 AB CAN Gasoline 0.3217
yogeswaran K
  • 2,278
  • 8
  • 29
  • 45
-1
votes
2 answers

ORA-19112: error raised during evaluation while converting comma separated strings to rows using XMLTABLE

I am trying to split comma separated strings into rows using XMLTABLE function in oracle. e.g. WITH MYTABLE AS (SELECT '"AB","PQ","XY"' TEXT FROM DUAL ) SELECT REPLACE((column_value).GETSTRINGVAL(),'"','') "OPTION_TEXT" FROM MYTABLE, …
Krishnat Molawade
  • 216
  • 3
  • 17
-1
votes
2 answers

Show XML in a table using xsl

Let's say I have this XML file
FALSE FALSE FALSE
FALSE FALSE FALSE
Now…
Epligam
  • 741
  • 2
  • 14
  • 36
-2
votes
1 answer

XML TABLE SQL Server

I am trying to convert my DB2 stored procedure to SQL Server and I'm not sure about this xmltable function DECLARE @IN_AR_UTL_DATA_XML XML DECLARE @WS_ACCOUNT_NO DECIMAL(13,0) DECLARE @WS_BILL_NO INT …
nick
  • 323
  • 2
  • 14
-2
votes
1 answer

get all nodes that as the same atrribute on oracle xmltable using xquery

I´m looking for a way to get all nodes that as the same attribute on oracle xmltable using xquery ... For example, an xmltable with a xml with employees and relate items, I would like to retrieve all modes that in the node attribute / propriety like…
António Roque
  • 29
  • 1
  • 6
-5
votes
1 answer

Using xml to display a table on a page

I am trying to display a table using xml on an html page. Basically the: xml will serve as the file that will store the data to be out putted on the table the dtd file that defines the datatype of the listing and an xsl file that would tell the…
user3215045
  • 75
  • 1
  • 11
1 2 3
…
18
19