Stack Overflow
Stack Overflow

Questions tagged [nested-table]

Table containing another table (hierarchical table)

236 questions
4
votes
2 answers

plsql difference between two Nested Table collections

I have two PLSQL Arrays of type nested table: TYPE nested_typ IS TABLE OF VARCHAR2(21); nt1 nested_typ := nested_typ('abc','def','123'); nt2 nested_typ := nested_typ('123'); I want to have the difference of these two collections, for above Ex:…
Sekhar
  • 243
  • 1
  • 4
  • 12
3
votes
2 answers

How to scrape HTML table with nested column with Rvest?

I encounter a big problem in scrapping of HTML table with nested columns. The table is from the immigration department of Hong Kong. A screenshot is shown here: I tried to do it with rvest, but the result is…
ronzenith
  • 341
  • 3
  • 11
3
votes
1 answer

PL/SQL package type vs schema type

What I'm trying to do is the following: create or replace package MyPackage as type string_list_t is table of varchar2(32767); function GetPrimaryKeys ( p_table_name varchar2, p_owner varchar2 ) return string_list_t; end…
vines
  • 5,160
  • 1
  • 27
  • 49
3
votes
3 answers

BigQuery Insert into Nested records

I have a table that has a nested record (please see attached snapshot). I am trying to do a simple insert but it's not working. INSERT INTO `my_project.my_dataset.test_table`(name,address,comments) values( 'my_name' as name, [STRUCT('ABC' as…
Dinesh
  • 309
  • 3
  • 14
3
votes
1 answer

How can I have nested mat-table sortables?

Ciao, I'm playing with Angular 8 and I need one main table with expandable rows and for each row I need see the the details. My actual problem is that the sorting works only on father table and not on the children ones. This is my HTML code:
ilMattion
  • 1,841
  • 2
  • 24
  • 47
3
votes
2 answers

react-data-table-component with nested tables

I am using react-data-table-component in a node/react page. I have 2 data sets, List and ListNested. list is a collections of document data (xlsm to be specific) that has the most recent version of the document on each row. listNested is a similar…
cHam
  • 2,624
  • 7
  • 26
  • 28
3
votes
2 answers

Is it possible to get metadata on a nested table/array from Java code?

Normally for a user defined type I can simply do the following (Simplified but functional example): //Create table create type myType1 as object( a char(2), b char(2) ); create type myTable1 as table of myType1; //Java code ArrayDescriptor des =…
billoot
  • 77
  • 15
3
votes
1 answer

access nested tables from Lua to C to get values

Hi I am trying to access a nested table sent from Lua to C. The table is: arg = { MagicNumber = {MagicNumber, 0}, ProdNum = {ProdNum, 1}, LetterR = {LetterR, 0xc}, Revision = {Revision, 0xd}, Space1 = …
SanR
  • 43
  • 5
3
votes
2 answers

How to solve single-row subquery returns more than one row

I have an employee table and it contains salary table. I want to give %10 increase to all current employees. I tried to update all employees' salary dates to specific date but I encountered problem with single-row subquery. My database like…
Yusuf Çakmak
  • 45
  • 7
3
votes
2 answers

What is maximum rows count in oracles nested table

CREATE TYPE nums_list AS TABLE OF NUMBER; What is maximum possible rows count in oracle's nested table ? UPDATE CREATE TYPE nums_list AS TABLE OF NUMBER; CREATE OR REPLACE FUNCTION generate_series(from_n NUMBER, to_n NUMBER) RETURN nums_list…
Oto Shavadze
  • 40,603
  • 55
  • 152
  • 236
3
votes
1 answer

Oracle Execute Immediate with DDL and Nested table

I have a problem trying to use an Execute Immediate statement containing a CREATE TABLE statement and a user defined Table Type. I get error ORA-22905 on Oracle 11g. Is there any workaround to solve this issue? CREATE TYPE MY_TABLE_TYPE AS TABLE OF…
andreaplanet
  • 731
  • 5
  • 14
3
votes
2 answers

Using Nested Table variables / Collections in SQL inside PL/SQL blocks

I first create an address_type object CREATE TYPE address_type AS OBJECT ( line1 VARCHAR2(100) , line2 VARCHAR2(100) , line3 VARCHAR2(100) , city …
Rachcha
  • 8,486
  • 8
  • 48
  • 70
2
votes
2 answers

How could I use ngFor to design this (maybe nested) table

I have an Object Array that has a key and then has an array for it's value. Something like this: [ {key: 'example@example.com', value: ['message1', 'message2']} ] I previously had this working using an object like this [ {key:…
new_programmer_22
  • 453
  • 4
  • 23
2
votes
2 answers

Can an Oracle stored procedure that has a nested table parameter be called from ODP.NET?

I've got a stored procedure that has a couple parameters that are nested tables. CREATE TYPE FOO_ARRAY AS TABLE OF NUMBER; CREATE TYPE BAR_ARRAY AS TABLE OF INTEGER; CREATE PROCEDURE Blah( iFoos IN FOO_ARRAY, iBars IN BAR_ARRAY, oResults OUT…
Rotaerk
  • 231
  • 3
  • 4
2
votes
0 answers

wkhtmltopdf | Nested Table HTML to PDF | Blank Space issue

We are using nested table . While converting html to pdf with the help of wkhtmltopdf we are facing blank space problem. There are some scenarios which I would like to discuss which is based on table line items. When table line items is less…
Pankaj Pawar
  • 76
  • 1
  • 9
1
2
3
…
15 16