Stack Overflow
Stack Overflow

Questions tagged [nested-table]

Table containing another table (hierarchical table)

236 questions
10
votes
2 answers

Wrapping a C library for Lua: how do I create nested tables of functions?

The code related to this question is here: https://github.com/jchester/lua-polarssl/tree/master/src Currently I'm trying to wrap one part of the PolarSSL library (http://polarssl.org) to give me access to SHA-512 HMACs (luacrypto does not provide…
Jacques Chester
  • 628
  • 1
  • 4
  • 13
10
votes
1 answer

Oracle SQL: select from table with nested table

I wonder how can i make select statement from table which have a typed column ? Type of this column is defined as: create or replace TYPE "MYCOL" as table of MYTYPE; create or replace TYPE "MYTYPE" as OBJECT ( myid Number, myname…
Igor Konoplyanko
  • 9,176
  • 6
  • 57
  • 100
7
votes
3 answers

Show/Hide or Toggle Nested Table Child In Tabulator

I was wondering if you could help with something I believe to be pretty simple. Using the Tabulator nested table example(Not Tree), how can I make the child table show/hide on click? I want users to be able to expand for further information if they…
Ben Tongue
  • 215
  • 4
  • 10
7
votes
2 answers

"ORA-22812: cannot reference nested table column's storage table" when trying to access system table

I have a table in my Oracle 12c Database XML Schema creation: BEGIN -- Register the schema DBMS_XMLSCHEMA.registerSchema('http://www.example.com/fvInteger_12.xsd', '
Siqueira
  • 423
  • 1
  • 7
  • 29
7
votes
1 answer

Meaning of STORE AS in nested table in PL/SQL

I referred many examples of "Creating a SQL Type Corresponding to a PL/SQL Nested Table" such as CREATE TYPE CourseList AS TABLE OF VARCHAR2(64); CREATE TABLE department ( name VARCHAR2(20), …
YLG
  • 855
  • 2
  • 14
  • 36
6
votes
1 answer

update multiple records in multiple nested tables in oracle

I have an oracle table with nested tables in some of the columns. Now, I need to be able to update all the records in each nested table, in each of the records of the main table. How is this accomplished? Any of the ways that I've tried, I get…
chrismarx
  • 11,488
  • 9
  • 84
  • 97
5
votes
1 answer

Create nested table using react-table v7

thanks for your help in advance. The problem that I am trying to solve is to create a table with react-table v7 and within that table using the expand and display another table with data related to the first selection as it is attached in the…
Cristian Turcios
  • 63
  • 1
  • 6
5
votes
3 answers

Difference between NESTED TABLE and VARRAY

I know basic difference and uses of both. But, what I'm looking for as an answer is, why exactly VARRAY introduced ? Since, we can do same thing using NESTED TABLE what can be done using VARRAY whereas vice-versa is not possible in some scenario.…
Ravi
  • 30,829
  • 42
  • 119
  • 173
4
votes
2 answers

Hibernate and Oracle VARRAYS/NESTED TABLE

Oracle supports the use of VARRAYS and NESTED TABLE data types, allowing multivalued attributes. (http://www.orafaq.com/wiki/NESTED_TABLE) I am currently using Hibernate 3 as my ORM framework, but I can't see how I can map Hibernate to a NESTED…
TBW
  • 128
  • 1
  • 9
4
votes
1 answer

Can I pass a list of String in the IN clause of sql statement(Oracle) using Java code

Can I pass a list of String in the IN clause of sql statement(Oracle 12c) using Java code. My code is given below: Connection con= abc.getConnection(); OracleConnection oracleConnection = null; OraclePreparedStatement ops=null; if…
Amandeep Singh
  • 65
  • 1
  • 6
4
votes
1 answer

How to get value from nested table in pl sql table

I have created nested table as follow: CREATE OR REPLACE TYPE EMP_NO_NAME AS OBJECT ( EMPNO NUMBER(4), ENAME VARCHAR2(20), JOB VARCHAR2(20), MGR NUMBER(5), HIREDATE DATE, SAL NUMBER(7,2) ); CREATE OR REPLACE TYPE EMP_TABLE IS TABLE OF…
shashank
  • 79
  • 1
  • 8
4
votes
5 answers

Set Dynamic Cell's Table View Content height to table view height constraints ios

I have tableview(A)'s every custom cell having tableview(B) with dynamic table view cell. At tableview(A) cellForRowAtIndex. - (UITableViewCell *)tableView:(UITableView *)tableView cellForRowAtIndexPath:(NSIndexPath *)indexPath{ …
Ravi Kumar
  • 1,356
  • 14
  • 22
4
votes
2 answers

What is the difference between nested array and associative array?

There are two links http://docs.oracle.com/cd/E11882_01/appdev.112/e25519/composites.htm#LNPLS99981 and Purpose of using different types of PL/SQL collections in Oracle by referring above two links i have two doubt 1.Which one is correct nested…
Puneet Kushwah
  • 1,495
  • 2
  • 17
  • 35
4
votes
2 answers

Lua - Getting values from nested tables

Okay so I have been searching everywhere for this, but nowhere has the answer. I have a nested table (an example): { { "Username", "Password", "Balance", }, { "username1", "password1", 1000000, }, { …
Dahknee
  • 591
  • 3
  • 12
  • 28
4
votes
4 answers

Semantic of nested tables and table header

I have a table where elements can have child elements with the very same attributes, like: ITEM ATTRIBUTE 1 ATTRIBUTE 2 item value value sub value value sub value value item value value From…
lampshade
  • 2,470
  • 3
  • 36
  • 74
1
2 3
…
15 16