You can create a table with a column whose datatype is another table. That is, tables
can be nested within other tables as values in a column. The Oracle database server
stores nested table data out of line from the rows of the parent table, using a store
table that is associated with the nested table column. The parent row contains a
unique set identifier value associated with a nested table instance.
嵌套表
1. 一个表的某列的数据类型可以为另一个表.即一个表可以作为一个列值嵌套在表中.
2. Oracle 数据库将嵌套表的数据存储在其父表的数据行之外的对应的嵌套列的存储表
父表中的每行包含一个指向嵌套表对象的标识.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10599713/viewspace-981303/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
-
博文量740
-
访问量2002946
最新文章
- 人力&人手&人才&人物
- oracle树中prior的用法
- Using Supplied Packages to Manage Stored Outlines
- $ORACLE_HOMERDBMSADMIN目录下各SQL的含义
- PRODUCT_USER_PROFILE Table
- Backing Up Server Parameter Files with RMAN
- Backing Up Control Files with RMAN
- Backing Up Individual Tablespaces with RMAN
- Making Whole Database Backups with RMAN
- 目睹奥运火炬传递
