Stack Overflow
Stack Overflow

Questions tagged [nested-table]

Table containing another table (hierarchical table)

236 questions
1
vote
1 answer

Render three level hierarchy from collections to mvc view

I'm trying to represent a 3-level nested collection on an MVC view. Here is my code: @*Accounts*@ @for (var counterAccount = 0; counterAccount <…
DoomerDGR8
  • 4,840
  • 6
  • 43
  • 91
1
vote
2 answers

Referring a nested table in a relational insert query

Below are the object types I have. Basically I have a person table and a child table as a nested table of person table. I have a School table with a M:N Relationship with child table (nested). So I'm creating a intermediate table to insert…
Nipuna
  • 6,846
  • 9
  • 64
  • 87
1
vote
1 answer

how to add an element into a nested table in sql (oracle)?

Supposing i am using a table person, and persons might have multiple last names, so that attribute should be stored in a nested table (it's not about where to store last names), here is a simple sql for creating the type last name, the table person…
BHA Bilel
  • 331
  • 5
  • 14
1
vote
2 answers

Adding a virtual column in SELECT statement from a list of value of a subquery in Oracle dynamically

I need to add a virtual column on the result of a subquery in dynamic way. I need to add n virtual column as n value inside a nested table nt for each result of the subquery. I mean, for example I have a nested table nt of 7 results, i.e. nt =…
Giacomo Brunetta
  • 1,409
  • 3
  • 18
  • 38
1
vote
1 answer

Add a column to a nested table

I've this table parlamentari --------------- id|nome|cognome Can i add in this table a nested column called telefoni? I tried with create table or replace type telefoni_nt as table of varchar2(10) after dnn; alter table parlamentari add telefoni…
keiichi
  • 113
  • 1
  • 1
  • 10
1
vote
2 answers

How to get n element from nested table pl/sql?

I have problem with the compilation of my stored procedure. create or replace type CartLine as object ( offeringId OfferingIdList ,productLine varchar2(50) ,equipment char(1) ,installment CHAR(1) …
anton1009
  • 33
  • 2
  • 7
1
vote
1 answer

Hierarchical html table, putting last td on next line

I'm creating a simple hierarchical table with html and CSS and I'm getting into trouble with formatting the last td element with class .child to be on next line. I want to have the nested table inside table > tr > td.child becase each table can be…
Juraj Blahunka
  • 17,913
  • 6
  • 34
  • 52
1
vote
2 answers

How to pass table to row to form nested table through jQuery?

I have a records in DataTable with a checkbox. I am trying to append new table to the row on clicking the checkbox. I am trying to do something like this. Here they are taking values from row and formatting it and displaying back. But I have…
Ali Sheikh
  • 45
  • 1
  • 1
  • 12
1
vote
1 answer

Eloquent whereNotExists not generating correctly

I have the following SQL which pulls a root node from a nested table (relative to the user, i.e. this highest node to which a user is assigned), SELECT child_domain.*, child_subscription.user_id FROM domains AS child_domain JOIN…
DGeo
  • 275
  • 1
  • 3
  • 7
1
vote
1 answer

Oracle-PL/SQL Functions with return type nested table Error Type is incomplete or malformed

CREATE TYPE dname AS OBJECT ( depno NUMBER, cnt_dname NUMBER ); / CREATE TYPE nt_dname_dname AS TABLE of dname; / CREATE OR REPLACE FUNCTION f1 RETURN nt_dname AS nt_dname t_d := t_d(); n NUMBER :=…
user8043289
  • 13
  • 4
1
vote
1 answer

Select query from nested table of references

I have two object-relational tables: person_table and account_table, built out of objects person and account. An account row has a nested table for all the people sharing this account, its type is 'customer_list'. create type person as object( id…
Guilhem Fry
  • 326
  • 4
  • 17
1
vote
2 answers

Nested tables: Insert values into specific columns of nested table

I have a question regarding insert query for a nested table. I have an object like this: CREATE OR REPLACE TYPE obj_animals as OBJECT ( row_id INTEGER, animal_id INTEGER, attr1 VARCHAR2(30), attr2 VARCHAR2(30), attr3 VARCHAR2(30) …
Neptune_Runner
  • 61
  • 1
  • 1
  • 6
1
vote
2 answers

Oracle sql select data from table where attribute is nested table

I have a objects: create type t_history_rec is object ( date_from date, current float ); create type t_history is table of t_history_rec; and table defined: create table person ( id integer primary key, name varchar2(30), history…
GoobyPrs
  • 585
  • 2
  • 7
  • 15
1
vote
0 answers

Datatables.net multiple Nested tables (collapse doesn't work)

I created a demo to play with Datatables and nested tables. I wanted to have multiple level of parent/child with collapse/expand. I was able to create 3 levels of tables, but when I want to collapse the 2th nested table, Datatables is not able to…
Sebastien Dionne
  • 757
  • 2
  • 19
  • 34
1
vote
1 answer

oracle sql - merge table with nested table as column

I have 2 tables and one nested table: 1.stores data about products which include following columns: ITEM - product id(key) STORE - store id(key) PRICE NORMAL_PRICE DISCOUNTS - nested table with info about discounts include…
Panteleev Dima
  • 175
  • 2
  • 18
1 2 3
…
15 16