Get information on your nested tables from the user_nested_tables view : user_nested_tables « System Tables Data Dictionary « Oracle PL/SQL Tutorial

Home
Oracle PL/SQL Tutorial
1.Introduction
2.Query Select
3.Set
4.Insert Update Delete
5.Sequences
6.Table
7.Table Joins
8.View
9.Index
10.SQL Data Types
11.Character String Functions
12.Aggregate Functions
13.Date Timestamp Functions
14.Numerical Math Functions
15.Conversion Functions
16.Analytical Functions
17.Miscellaneous Functions
18.Regular Expressions Functions
19.Statistical Functions
20.Linear Regression Functions
21.PL SQL Data Types
22.PL SQL Statements
23.PL SQL Operators
24.PL SQL Programming
25.Cursor
26.Collections
27.Function Procedure Packages
28.Trigger
29.SQL PLUS Session Environment
30.System Tables Data Dictionary
31.System Packages
32.Object Oriented
33.XML
34.Large Objects
35.Transaction
36.User Privilege
Oracle PL/SQL Tutorial » System Tables Data Dictionary » user_nested_tables 
30.87.1.Get information on your nested tables from the user_nested_tables view
SQL>
SQL> desc user_nested_tables;
 Name          Null?    Type

 TABLE_NAME             VARCHAR2(30)    Name of the nested table                                          
 TABLE_TYPE_OWNER       VARCHAR2(30)    User who owns the nested table type                               
 TABLE_TYPE_NAME        VARCHAR2(30)    Name of the nested table type                                     
 PARENT_TABLE_NAME      VARCHAR2(30)    Name of the parent table that contains the nested table           
 PARENT_TABLE_COLUMN    VARCHAR2(4000)  Name of the column in the parent table containing the nested table
 STORAGE_SPEC           VARCHAR2(30)    Storage specification for the nested table                        
 RETURN_TYPE            VARCHAR2(20)    Return type of the column                                         
 ELEMENT_SUBSTITUTABLE  VARCHAR2(25)

SQL> CREATE Or Replace TYPE AddressType AS OBJECT (
  2    street VARCHAR2(15),
  3    city   VARCHAR2(15),
  4    state  CHAR(2),
  5    zip    VARCHAR2(5)
  6  );
  7  /

SQL>
SQL> CREATE Or Replace TYPE nested_table_AddressType AS TABLE OF AddressType;
  2  /

Type created.

SQL>
SQL> CREATE TABLE employee (
  2    id         INTEGER PRIMARY KEY,
  3    first_name VARCHAR2(10),
  4    last_name  VARCHAR2(10),
  5    addresses  nested_table_AddressType
  6  )
  7  NESTED TABLE
  8    addresses
  9  STORE AS
 10    nested_addresses;

Table created.

SQL>
SQL>
SQL> --SELECT FROM user_nested_tables;
SQL>
SQL>
SQL> drop table employee;

Table dropped.

SQL>
SQL>
30.87.user_nested_tables
30.87.1.Get information on your nested tables from the user_nested_tables view
java2s.com  | Contact Us | Privacy Policy
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.