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
2
votes
2 answers

Using xmltable in Postgres

Does anyone have experience in using XMLTABLE function in postgres they could help me out with. I have a text column in a table that contains XML data that I would like to convert into separate records. A sample of the data is shown…
user2699504
  • 195
  • 1
  • 4
  • 18
2
votes
1 answer

Need help parsing XML and storing in Oracle table

I am trying to parse this sample output and storing the rows in this xml as rows in table, column names will the name="...." in the rows. There will be upto 100 rows in resultset, I'm including just one below as example.
oracle_of
  • 23
  • 6
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
1 answer

PLSQL XML into table by tag and value

In PL/SQL, is it possible to convert XML into a table split by tag and value without hardcoding any columns? Example XML: That is not a valid request A11 …
Mocking
  • 1,764
  • 2
  • 20
  • 36
2
votes
1 answer

Rendering table column data in React

I currently have a table display a couple of rows with different columns that I defined using array mapping. However, I want the last column or every row to have a button, but right now when I try to log text, it doesn't even show up. Why is this?…
JorahFriendzone
  • 439
  • 1
  • 4
  • 21
2
votes
1 answer

How to display a table which is generated programmatically in a .aspx-Website

I've got a problem with displaying a table which is generated programmatically. Let me explain. I have a XML which is looking like this:
Header
…
Fryndorfer
  • 73
  • 10
2
votes
2 answers

Using variable to define path in XMLTable in Oracle

I'm learning how to use XMLQuery and XMLtable features in Oracle 11g and I'm trying to use a variable instead of a specific string in XPath, when using a XMLTable query. For example: DECLARE px_return XMLTYPE := XMLTYPE ( …
milheiros
  • 621
  • 2
  • 14
  • 34
2
votes
1 answer

Oracle 11g: Extract data from XML using xmltable, xmlagg and pivot

I have the following XML: 02220cim a2200325 a 4500 P286
giluy
  • 33
  • 4
2
votes
2 answers

XML/XSL table formatting

Let's say I have a list of 500 names in XML tags. I want to display this list in a table using XSLT. In the XSLT table I want to have a maximum of three rows; I don't care how many columns I have - I plan to put the table into a scrollable div. …
War Chester Shire Sauce
  • 23
  • 1
  • 5
2
votes
2 answers

oracle xmltable get children nodes

António Roque
  • 29
  • 1
  • 6
2
votes
1 answer

oracle xmltable with columns from another table

with oracle xmltable SELECT u.* FROM table1 , XMLTable('/abc/def[contract = $count]' PASSING xmlcol, 1 as "count" COLUMNS contract integer path 'contract', oper VARCHAR2(20)…
Pradeep Mohite
  • 31
  • 2
2
votes
1 answer

Splitting two interdependent strings into rows

I have two comma-separated strings like this: 'number1,number2,number3' 'word1, word2, word3' And I want to split them into rows keeping the order of values. The expected result is: COL1               COL2 ------------------------- number1        …
Aleksey
  • 23
  • 2
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
2 answers

Selecting from and inserting to complex Oracle XMLTYPE data

I've written simple Oracle queries to extract XMLTYPE data before, but this XML is different - I need to pull information from attributes, child elements, and their respective attributes. I also would like to write an INSERT statement as well…
Slothario
  • 2,830
  • 3
  • 31
  • 47
2
votes
1 answer

XMLTABLE in oracle - XQuery dynamic type mismatch: expected singleton sequence - got multi-item sequence

Declare lv_xmldata XMLType := XMLType('
beetri
  • 1,039
  • 11
  • 24
  • 40
1 2
3
…
18 19