Stack Overflow
Stack Overflow

Questions tagged [nested-table]

Table containing another table (hierarchical table)

236 questions
1
vote
1 answer

Table with nested rows with different colspans

I am trying to create a element with nested rows and different colspans. Here is a little wireframe to show what I mean. How do I approach this?
SaroGFX
  • 699
  • 6
  • 20
1
vote
1 answer

Remove duplicate tables in a nested table. Lua

Before you mark this question as duplicate of this please read the whole thing: I have a table in Lua which is a table of tables something like the below one and I want to remove all the duplicate tables in it. table1 = {{1, 2, 3}, {1, 2, 3}, {1, 2,…
Rajat Shenoi
  • 590
  • 2
  • 7
  • 22
1
vote
2 answers

How to Group By all columns of table A when joining two tables to create one big nested table on BigQuery?

I'm trying to create a big nested table that would be composed of many tables, such as my Clients table, Phone Numbers, Emails... They all have in common the client_id field. For the moment I have to following query that works well ("join" the…
Harvey
  • 213
  • 1
  • 3
  • 12
1
vote
1 answer

Nested Tables in a stored procedure

The PL/SQL script shown below is failing to execute at line # 20: declare type string_table is table of varchar(100); v_names string_table := string_table(); begin v_names.EXTEND(3); v_names(1) := 'name1'; …
UncleZen
  • 289
  • 1
  • 4
  • 22
1
vote
2 answers

Print values of TABLE OF RECORDS TYPE without knowing the COLUMN NAMES of record

I have created a Procedure which uses a View to PRINT (into CSV ) , all the records of that view. Any user can drop and recreate that view , so its column structure can change Is there any way to FETCH all records of VIEW into a collection and PRINT…
Swechchha
  • 38
  • 7
1
vote
2 answers

Oracle SQL create identity column in nested table

I'm making a table which contains nested table: create DOCUMENT as OBJECT ( DOC_ID NUMBER, DESCRIPTION VARCHAR(1000)); create type documents_t is table of DOCUMENT; create table projects ( ID NUMBER GENERATED ALWAYS AS IDENTITY , …
Izik
  • 746
  • 1
  • 9
  • 25
1
vote
1 answer

Thymeleaf nested Set
I'm having a problem accessing a nested Set of objects. I have defined the below objects : @Getter @Setter @AllArgsConstructor @NoArgsConstructor @Entity @Table(name = "site") public class Site { @Id @GeneratedValue(strategy =…
Jarek Brocki
  • 129
  • 1
  • 9
1
vote
1 answer

Nested tables in database

I am working on a project, that has multiple processes and each process has different data items to process. Data items (For different processes) have different columns (but always the same columns for the same process). At first, I assumed that it…
Oskars
  • 407
  • 4
  • 24
1
vote
1 answer

How to fill a table with data which contains a nested table of references in Oracle?

I am trying to create a database of a conference. There are tables like Authors, Papers and a relation table. The Papers table contains the title of research and a nested table of reference to authors (because a study can be written by more than one…
PRR
  • 11
  • 2
1
vote
1 answer

AutoMapper 9 mapping nested tables

I'm using AutoMapper 9 and I want to mapping my nested table. In older version of AutoMapper I've used "CreateMap" like this: CreateMap().AfterMap((s, d) => Mapper.Map(s.Table2, d)).ReverseMap(); I've found this example below but…
Kamil
  • 155
  • 2
  • 8
1
vote
2 answers

I got the error ORA-06531: Reference to uninitialized collection

Im creating a procedure to display the n number of maximum and minimum salary for an employee. If i ll give 5 as input, the query will get me 5 maximum and minimum salary for an employee. For the above scenario, I have created an object with two…
Raja sekar
  • 79
  • 2
  • 11
1
vote
0 answers

Using nested datatable in laravel and build my own json

I am using Nested-datatables (https://github.com/AndrejGajdos/nested-datatables) so I have to use JSON. I want to pass JSON from the controller to ajax and then use it in order to create a nested table. The problem is that I need the exact JSON…
m.m
  • 41
  • 1
  • 5
1
vote
2 answers

How can I return a own type data in oracle stored procedure?

I create a type data in oracle for a procedure. procedure: create or replace TYPE ROW_USER as object ( ID NUMBER(4), ROLES_ID NUMBER(1), FIRST_NAME VARCHAR2(60 BYTE), SECOND_NAME …
Diego F
  • 19
  • 1
1
vote
1 answer

How to set a Limit on Bulk Collect with a Nested Table PL/SQL Collection?

I'm trying to set a limit on a database query with the limit keyword. This is my current working query without the limit keyword. DECLARE TYPE NESTED_TABLE_DECLARATION IS TABLE OF SCHEMA.TABLE_NAME%ROWTYPE; NESTED_TABLE…
Matt
  • 135
  • 3
  • 17
1
vote
0 answers

React nested table component

I want to build nested table in my current POC but my parent and child table header and data are different. As I new to React I was not able to build on own. Is there any UI component or Library which can suffice my requirement? I have explore…
Maddy
  • 164
  • 2
  • 13
1 2 3
…
15 16