【PL/SQL】Composite Data Type

最新推荐文章于 2024-11-06 10:20:58 发布

阿文PIONEER

最新推荐文章于 2024-11-06 10:20:58 发布

阅读量196

点赞数

分类专栏： oracle 文章标签： oracle

本文链接：https://blog.csdn.net/yawen9790/article/details/90720985

版权

本文详细介绍了PL/SQL中的复合数据类型，包括记录（Records）和集合（Collections）。记录用于处理相关但不同类型的逻辑数据单元，可以包含多个不同数据类型的字段，并且可以作为其他记录的组件。%ROWTYPE属性允许声明变量来表示数据库表或视图的一行。集合则存储相同数据类型的值，分为INDEX BY表格、嵌套表和VARRAY。集合提供了如EXISTS、COUNT等操作，而嵌套表和INDEX BY表格在存储和使用上有其特定区别。复合数据类型使得数据管理更为便捷，能将相关数据作为一个整体进行操作。

摘要由CSDN通过智能技术生成

Scalar data type only holds one value

Composite Data Types
Can hold multiple values (unlike scalar types)
Are of two types:
– PL/SQL records
used to treat related but dissimilar data as a logical unit
store values of different data types but only one occurrence at a time
Must contain one or more components (called fields) of any scalar, RECORD, or INDEX BY table data type
Are similar to structures in most third-generation languages (including C and C++)
Are user defined and can be a subset of a row in a table
Treat a collection of fields as a logical unit
Are convenient for fetching a row of data from a table for processing
Each record defined can have as many fields as necessary.
Records can be assigned initial values and can be defined as NOT NULL.
Fields without initial values are initialized to NULL.
The DEFAULT keyword can also be used when defining fields.
can define RECO