Stack Overflow
Stack Overflow

Questions tagged [nested-table]

Table containing another table (hierarchical table)

236 questions
1
vote
2 answers

how to insert into nested table collection using cursor plsql

I'm writing a function that needs to manipulate multiple rows at the same time and they need to be indexed. After several hours of reading about Oracle pl/sql I figured I could create a nested table kind of collection. Since I couldn't find a…
A_P
  • 331
  • 3
  • 15
1
vote
1 answer

Get an element's parent td that is directly below a tr with a certain class

I have a complex table structure in a web page as given below. There could potentially be deeper nesting of tables. I am trying to find a jQuery selector to find the closest td to a given input element, with the added constraint that the tr of this…
Sunil
  • 20,653
  • 28
  • 112
  • 197
1
vote
1 answer

Looking for a datatype which can be filled with BULK COLLECT INTO and then to be selected from with SELECT

I have a great problem with an PL-SQL package I'm currently working with. All I want to do is to create a small piece of code which will do this: In the IS section of a function: l_tabellen_excl DBMS_utility.name_array; Later in the code: SELECT…
hc0re
  • 1,806
  • 2
  • 26
  • 61
1
vote
1 answer

Outlook 2013 not displaying correct width for nested table for my eNewsletter

I have an eNewsletter I had to code for one of our clients. After coding everything I sent a test through our Constant Contact account. I tested Gmail, Yahoo & Mac Mail and they work fine. When I send it to an Outlook 2013 email it doesn't display…
Richard Johnson
  • 13
  • 5
1
vote
1 answer

HTML nested tables and list resulted unexpected output

I'm having incredible trouble using nested tables and lists in HTML. I swear I am constructing the HTML code correctly, using Sublime to help me make sure that all tags and end tags line up with each other and with proper indentation to keep track…
OMGitzMidgar
  • 689
  • 2
  • 10
  • 28
1
vote
1 answer

Getting 3rd level descendant in nested table

I have an HTML page with tables nested to the 3rd level. I need help with a jquery selector to select the 3rd descendant table. Please note the topmost table has an id of "mytable" but the nested ones have no id. Clarifying again: this is the 3rd…
user1729972
  • 712
  • 2
  • 9
  • 29
1
vote
2 answers

Does a nested table retain order while not being stored?

I have a PLSQL function that populates and returns a nested table: select distinct id bulk collect into my_nested_table from user order by id; return my_nested_table; According to the docs nested tables are multisets and have no inherent…
Roland
  • 7,525
  • 13
  • 61
  • 124
1
vote
1 answer

Include records that has a null value on INNER JOIN SQL Server query over a tree table

I'm querying over a table that has nested references to itself, and I need to get records has a null reference on the INNER JOIN value which i'm using. In other words, the tree table records may not reach the same depth and I need to get all of…
lerp90
  • 503
  • 8
  • 23
1
vote
0 answers

Nested table in email android gmail app

Ive done a html page to be used in an email. This has a nested table in which works fine in desktop browsers and email applications But when viewed in the gmail android app the width of the nested table decreases by 2px. Can anyone tell me why this…
Danny Pacey
  • 11
  • 2
1
vote
1 answer

What are the ways to query a Nested Table?

I created a nested table, now i want to query this table 1 way i know i.e "select * from pOrder;" so what are the other ways to query a nested table? CREATE TYPE typ_item AS OBJECT --create object (prodid NUMBER(5), price NUMBER(7,2) ) CREATE TYPE…
Puneet Kushwah
  • 1,495
  • 2
  • 17
  • 35
1
vote
1 answer

How to Copy data from table with a nested table column

I have a table that has one of its columns as a nested table. I want to copy data of this table to another. How do we frame the INSERT clause for this seems challenging: Consider. The field that is a nested table is phone_list whose type is a user…
user2275460
  • 339
  • 3
  • 14
1
vote
0 answers

What is the exact data type of a nested table's index?

This will probably never actually matter, but I am curious. A nested table's indices are of course some form of integer, but that could be represented as a NUMBER, or an INTEGER, or a PLS_INTEGER, or a BINARY_INTEGER, etc. Internally, what type (if…
Colin P. Hill
  • 422
  • 4
  • 18
1
vote
2 answers

Using a List to simulate a dynamic Table with nested table with

I can create a dynamic table with
    and
  • wich adjusts sizes of columns depending on content. but the proble is that when I apend a nested table inside a row, this nested table appears on the right of the row instead on bottom. this is the…
Pedro Justo
  • 3,969
  • 1
  • 17
  • 21
1
vote
2 answers

lua:How to use value from table 'A', in table 'B', which nested in table 'A'

In real project, TEST_TABLE would contain much of TEST_TABLE_NESTED, each with its own testVariable and bunch of testScript. test function from testScript would be used in C++ code, and TEST_TABLE_NESTED tables would be added automatically from C++…
Russel Ledge
  • 221
  • 3
  • 11
1
vote
1 answer

Passing nested tables from Lua to C

I have the following nested table defined in Lua. I need to pass it into my C++ program so that I can accurately read it's values. I know I can pass a single table to Lua using the lua_getglobal(L, "parameters") function. But in this case…
shaveenk
  • 1,983
  • 7
  • 25
  • 37
1 2 3
…
15 16