Table containing another table (hierarchical table)
Questions tagged [nested-table]
236 questions
0
votes
2 answers
Deleting specific record from nested table Oracle DB
I'm having problems deleting specific record from the table (ORACLE DB).
I have a table with a nested table inside of it.
Table structure looks like this: where ML - nested table
Name, City, ML(Brand, Model, ID, Year, Price)
What I need to do is…
user3074445
- 3
- 2
- 6
0
votes
1 answer
How to select columns from nested table which points to object references
I have type:
CREATE OR REPLACE TYPE something AS OBJECT(
name VARCHAR2(100),
nestedObjects objects
);
where objects type is table of references:
CREATE TYPE objects IS TABLE OF REF object;
and object is:
CREATE OR REPLACE TYPE object AS…
tgrabus
- 103
- 1
- 9
0
votes
1 answer
How to get table from nested table [PL/SQL]
I want get table from nested table.
Create table type:
CREATE OR REPLACE TYPE Name_list_t AS TABLE OF VARCHAR2(50)
Alter my table adding column nested table:
ALTER TABLE MOVIES ADD Movi_name_list Name_list_t NESTED TABLE Movi_name_list STORE AS…
estradowiec
- 241
- 1
- 4
- 15
0
votes
0 answers
Oracle Nested Table predicate in where clause
I have a table that supposed to be searched with multiple columns, which can have multiple values
create table t as select * from all_objects;
create bitmap index IDX_DATA_OBJECT_ID on T (DATA_OBJECT_ID);
create bitmap index IDX_LAST_DDL_TIME on T…
Slava Lenskyy
- 426
- 2
- 10
0
votes
1 answer
SDNestedTable expand does not work on iOS 7
After clicking on a cell it doesn't expand.
The issue is reported on github.
The issue occurs only for iOS 7. On previous versions everything works fine.
Sviatoslav Yakymiv
- 7,887
- 2
- 23
- 43
0
votes
2 answers
joining collections in oracle
can any one help me or provide me sample code where i have to loop through a collection based on condition . just like where clause in sql. your help is highly appreciated....
Here is my code:
create table MODEL1
(
model_id NUMBER ,
model_seq…
user2874043
- 1
- 2
0
votes
3 answers
Selector: Fastest way to get descendants of a specific level only
I have a table like:
lampshade
0
votes
1 answer
OCI doc says Cursor and Nested table have the same bind type SQLT_RSET but they don'thttp://docs.oracle.com/cd/B14117_01/appdev.101/b10779/oci05bnd.htm#422771
section PL/SQL REF CURSORs and Nested Tables in OCI
says SQLT_RSET is passed for the dty parameter.
If I use SQLT_RSET for the return value of a function that returns a table…
Walking Corpse
0
votes
1 answer
nested table with different variables as the rows with rI am attempting to make a nested table using the tables package in r that can then be added into a knitr document.
I would like to make a table where each row is a different categorical variable in the data set and each column is the frequency and…
user2460499
0
votes
2 answers
find which td the div is placed on in nested tablesHere is my problem. I have nested tables something like this
|
