Table containing another table (hierarchical table)
Questions tagged [nested-table]
236 questions
0
votes
1 answer
How can I select a particular row from a nested table?
I have a table that looks like this:
CREATE
OR
REPLACE
TYPE subaccount_nt
IS TABLE OF VARCHAR2(30);
CREATE
TABLE my_table
( contract_id NUMBER(38,0)
, subaccount SUBACCOUNT_NT );
Here's some sample data:
…
Mridang Agarwalla
- 43,201
- 71
- 221
- 382
0
votes
1 answer
Can I make item's item.cost will be the product.price * produce.quantity when I create table
I want the item's item.cost will be the produce.price * produce.quantity..
How can I do it when I the table item??
There is my SQL code:
create or replace type Product as Object(
product_code char(6);
product_name varchar2(6);
description…
nickzheng
- 1
- 1
0
votes
2 answers
ioS Nested table: shoots out and deaccelerates
Anyone knows how to create a nested table view where the nested table "shoots out and deaccelerates" when tapped upon on in iOS? (objective c)
I am thinking of an animation similar to this:…
0
votes
1 answer
How to show content of a nested table with a cursor in PL/SQL
I want to show the content of a nested table using a cursor. I've try the following but it does not work. The arguments in the "put_line" are not correct but I don't know why.
create or replace type toys_t as table of varchar2(40);
create or…
Bob darkside
- 13
- 1
- 5
0
votes
1 answer
PL/SQL find values within nested tables
Hi I have problem I don't know if anyone can help. I've
created nested tables and inserted values in in a table.
CREATE OR REPLACE TYPE tt_hours AS OBJECT(hours INTEGER, data NUMBER);
/
CREATE OR REPLACE TYPE tt_day AS VARRAY(7) OF…
user1332821
- 83
- 1
- 3
- 9
0
votes
1 answer
unnesting a table in oracle 10g
So I just created this trigger for my tables:
CREATE OR REPLACE
PROCEDURE POPULATE_ACTOR_QUOTES (id_actor char)
AS
CURSOR quote_recs IS
SELECT m.title,
m.year,
r.roleName,
q.quotechar
from…
dexter
- 1,347
- 2
- 9
- 7
-1
votes
1 answer
Insert array / nested table into table
I really apologise if answer already was given, but I could only find answers for php.
My problem is that I got nested table array "test_nested_table" that got values ('a','b','c'). I also got table "test_table" in the DB that got three columns…
Pavels Paukovs
- 13
- 3
-1
votes
1 answer
Is it possible to use star expression inside array_agg(struct expressions in BigQuery?
I am joining several tables into one nested, and I was wondering if I could use a star expression, for example,
SELECT t1.*, ARRAY_AGG(STRUCT(t2.*)) FROM t1 JOIN t2 on t1.col1=t2.col1 GROUP BY t1.*
I get an error, but I was wondering, maybe I could…
MStikh
- 368
- 4
- 21
-1
votes
1 answer
Is there general problem Nested Table sorting an Angular?
If I have only one datatable I can sorting all values correctly. But sometimes I have nested table. For examle user can select city on the table, after that (city has lots of location ) location showns and user can select one of location on the…
Gülay Uygun
- 51
- 10
-1
votes
1 answer
SQL bulk collect and fetch
I am writing a PLSQL function and I am not getting a return data from my nested table. Here is my code and it is returning zero data.
set SERVEROUTPUT ON;
CREATE OR REPLACE FUNCTION GETSummary(startDate DATE, endDate DATE)
RETURN SUM_OBJ_TABLE AS…
tita
- 107
- 1
- 5
-2
votes
1 answer
How to create nested table in html
I need to create an HTML table with an inner table like the below-given diagram:
[Example][1]
I'm confused if I should create two separate tables for both left side and right side table or combine them together in a single table
I tried below…
sfdc
- 97
- 1
- 1
- 2