|
Tutorial 12: Oracle 9i: PL/SQL Collections |
|
Page 2 of 2
Creating Nested Tables
The following example explain how to create a table type and then nest it in a table
Following syntax is used to display columns of the above table we write.
SQL > SELECT COLUMN_NAME, DATA_TYPE FROM USER_TAB_COLUMNS;
SQL > SELECT TYPECODE, ATTRIBUTES FROM USER_TYPES;
TYPECODE ATTRIBUTES
------------------------------ ----------
OBJECT 2
COLLECTION 0
To insert values into the above table we use the below given syntax
To query a nested table Oracle provides a new function THE. To select data from a field in the nested table we must have to flatten the table first. Function THE is used for this purpose.
Associative arrays (or) Index-by tables:
They are sets of key-value pairs. The keys are maintained unique. The key can be either an integer or a string. The unique key is created using primary key from a table. The types raw , longraw , rowid etc are not allowed as keys.
Creating Associative Arrays
Trackback(0)
|
TrackBack URI for this entry
Subscribe to this comment's feed
Show/Hide comments
Show/Hide comment form