Top "Nested-table" questions

Table containing another table (hierarchical table)

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 …

sql oracle oracle10g nested-table
Insert data into nested table

May I please have some help to Insert values into a table. The table is called PurchaseOrder_objtab. Here is …

oracle reference insert nested-table object-relational-model
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 …

sql oracle plsql associative-array nested-table
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 …

oracle plsql nested-table varray
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 …

oracle plsql nested-table
Datatables.net multiple Nested tables (collapse doesn't work)

I created a demo to play with Datatables and nested tables. I wanted to have multiple level of parent/child …

javascript jquery ajax datatables nested-table
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 …

sql oracle sql-update nested-table