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.

253 questions
27
votes
2 answers

Angular Material 2 Table Mat Row Click event also called with button click in Mat Cell

I am new to material 2 and I have implemented mat table and in which I have click event on row to open dialog and there is also a menu button in last column "Action" but on clicking on button it also open dialog box instead of opening menu. Table …
Nasiruddin Saiyed
  • 1,238
  • 1
  • 9
  • 24
10
votes
1 answer

Jasper list element inside table element with XML datasource

I'm trying to generate a report, using Jasper iReport Designer 5.6.0, with table that contains lists inside its cells. The generated table could look like this: To do this, I'm using the following XML file as datasource: …
mrm
  • 271
  • 1
  • 6
  • 12
9
votes
3 answers

Jasper iReport table returns an empty document although query works

I'm trying to create a report with Jasper iReport 4.5 and I'm using a table to show some of the data. The table is filled by a query, and when I check the preview of the query in the Query Editor, I get exactly the results that I wanted. But when I…
Stefan Schmitt
  • 215
  • 1
  • 2
  • 9
9
votes
2 answers

Using XMLTABLE and xquery to extract data from xml

I have the following piece of XML: …
ErikL
  • 1,870
  • 6
  • 28
  • 53
9
votes
2 answers

SELECT from table with Varying IN list in WHERE clause

I am facing a issue in project I am working on, I can not give you actual code but I have created a executable sample code as below Here temp and temp_id are two tables temp table contains comma separated list of ids which is VARCHAR2 temp_id…
eatSleepCode
  • 3,911
  • 6
  • 37
  • 77
8
votes
2 answers

Jasper table component

I am trying to generate a report containing a table. These are the important parts from the jrxml: …
teo
  • 1,353
  • 1
  • 14
  • 24
8
votes
2 answers

XMLAGG with RTRIM issue

Currently I have the following query: SELECT CASE WHEN ('[Param.3]' = 'SELECTED') THEN (SELECT RTRIM(XMLELEMENT("Rowset", XMLAGG(RW.R ORDER BY RW."ID")), ' ' ) AS Orders FROM TMTABLE UL,…
Soham Shah
  • 523
  • 2
  • 6
  • 26
7
votes
1 answer

Strange error with XMLTABLE on Oracle 11g

I am using Oracle 11.2.0.4.0 and have run several times into problems when XMLTABLE was involved. My latest problem can be demonstrated with the following example (which I designed to be as simple as possible): with data as ( select…
Branko
  • 71
  • 1
  • 3
7
votes
3 answers

Wrap within table-cell with long word in FOP

I have a table in FOP and it is working nicely until I get a very long word. The word then overwrites the cell ending in the table. I tried the wrap-option="wrap" within the table-cell and/or the block of the cell but it doesn't work **Total…
Thevagabond
  • 323
  • 2
  • 6
  • 28
5
votes
1 answer

ORACLE parsing XML flles

In one of my procedure I am parsing a remote stored XML file using a REST call (in APEX) and trying to find out nodes that contain specific terms. Here's a simplified example structure of the file. The search term in this example is 'cloud':
Sejal Parikh
  • 153
  • 9
5
votes
1 answer

antd Table Summary

I have an antd table where I want to summarize columns in the footer. However, I'm having issues getting them to line up properly with my columns. I've tried to use Row / Col to get it to match up but without much luck. Also it needs to be…
NSjonas
  • 7,200
  • 5
  • 42
  • 78
5
votes
2 answers

Angular 2-4 Mat-Table row in another component

I would like to know if I can place the mat table rows in another component different from the table component, here is an example: …
Pedro Fernandes
  • 336
  • 3
  • 10
4
votes
1 answer

XSL FO continued / running tables, markers in footer

I am using markers and "retrieve-table-marker" in XSL-FO to create footers in a PDF transformation. I need a solution where a one-column table has a "clean" footer and a multi-column table has a footer with added text ("continued") before each…
Joneth
  • 91
  • 1
  • 9
4
votes
1 answer

Parsing multiple columns from XMLTYPE

I want to select data from a XML file using Oracle SQL. Here is my XML file: 0 1 …
Jordan Cortes
  • 261
  • 2
  • 15
4
votes
3 answers

Oracle XMLTable- fetching column from parent node

I have the following XML structure: 1 10000 11 1000 …
Rachcha
  • 7,626
  • 8
  • 45
  • 68
1
2 3
…
16 17