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
4
votes
1 answer

xsl fo center a table and an image using display-align="center"

I'm learning xsl:fo and training using the xml example file on w3schools : https://www.w3schools.com/xml/cd_catalog.xml, which I modified a bit to add a "PICTURE" tag. I parse the file to gather the information of each CD in a table, using…
Micawber
  • 707
  • 1
  • 5
  • 19
4
votes
1 answer

Tree Table OData Binding, SAPUI5

I am trying to create a tree table from an EntitySet (say E1), in my FIORI App. I have my controller and extended View and the data is properly bound between the two. I am referring to the Official SAP Demo Explored Kit for the tree table code.…
guitar_geek
  • 498
  • 2
  • 9
  • 19
4
votes
1 answer

How to make items (columns) in hyperlink?

I successfully created tables with style that salesforce provided. (like the one that highlighted on mouseover etc) But I want the value of column to be a link to display detail info of the object. When I don't create my own visualforce page, the…
Meow
  • 18,371
  • 52
  • 136
  • 180
4
votes
1 answer

XSLT to output plain text table

I'm working on an XSL template to convert an XHTML/hResume document to plain text, and I'm having trouble with the table layout (no, not layout tables). At the moment I've got the following, using the excellent Dave Pawson's padding…
l0b0
  • 55,365
  • 30
  • 138
  • 223
4
votes
1 answer

Convert flat XML table data where elements are concatenated row and column names into nested XML, using XSLT 1.0

I have XML output representing a table of data being output like this: Henry P162 23 John P137 27 …
Jasonovich
  • 621
  • 5
  • 13
4
votes
0 answers

XML Oracle - Extract Repeating Nodes

I have xml doc loaded in to xmltype column in Oracle 11g. My doc has repeating nodes that I need to flatten. I have been using XMLTable but get the singleton error. I found a solution if child nodes were involved, but cannot get it to work with…
rbgilder
  • 41
  • 3
3
votes
6 answers

JRXML - Display a checkbox in a table

I can't manage to display a checkbox in a table in jrxml. Here is a sample of my code:
Hal
  • 591
  • 4
  • 10
  • 28
3
votes
1 answer

Parse xmltype into table after pivot xml

i have return XMLTYPE after pivot xml that looks like Ukraine 12345 Germany …
Irochka
  • 33
  • 4
3
votes
1 answer

insert into varchar2 column select from xmltype column: extremely slow

I am using oracle10gR2 10.2.0.4 and solaris10 64bit I need to select data value from an xml in a xmltype column table (word.testmeta) and insert into another table (word.testwordyy) desc word.testmeta; Name Null? Type …
pangjiale
  • 145
  • 1
  • 1
  • 10
3
votes
2 answers

Two-column tables using XSLT

Here is a fraction of the XML data I am processing SYSTEM …
Levon Alikhanov
  • 103
  • 4
  • 13
3
votes
1 answer

XSLT WordML table with dynamic columns based on number of nodes

I have a number of xml files from which I'm trying to create a WordML table. There are a number of nodes in each nodelist, and I need to create a column for each one, up to a maximum of 15 columns. However, if there are less than 15, the columns…
user1791895
  • 31
  • 1
2
votes
1 answer

How to select specific values from XML using Oracle Xquery

Here is an example of the XML I'm trying to get some values from: text/xml; subtype=gml/3.1.1 …
Rene
  • 10,391
  • 5
  • 33
  • 46
2
votes
1 answer

To create an spreadsheet document in OPEN XML and and add an TABLE to it

I am trying to create an spread sheet by open xml with an table. But while opening the created excel file always it returns the error "Excel found unreadable content in test1.xlsx, do u want to recover. Why this error always happens? When the excel…
gany
  • 21
  • 1
  • 3
2
votes
1 answer

iReport 4.1.3 table component never shows the first entry of the dataset

I have a probably simple problem when using ireport table component. I'm using XML as the datasource for the report. The problem is that the table never shows the first entry of the dataset associated with it. Imagine I have this data: …
nunopato
  • 55
  • 3
  • 10
2
votes
1 answer

XML Content Modification in Oracle 11g r2

I've been dealing with a problem in Oracle XML DB (11g R2) as described below: Say in a table with a XMLType column named "xml_document" I have the following xml document …
Semih Yagcioglu
  • 4,011
  • 1
  • 26
  • 43
1
2
3
…
18 19