Detailed use of RECORD, VARRAY, and TABLE in ORACLE, oraclevarrayLimit limit 1 Description 1.1 RECORD
Define the record data type. It is similar to the STRUCTURE in C language. PL/SQL provides a holistic approach to combine several related,
Use of RECORD, VARRAY, and TABLE in ORACLE
1 Description
1.1 RECORD
Define the record data type. It is similar to the STRUCTURE in C language. PL/SQL provides a holistic approach to combine several related, separated, and basic data type variables,
PL/SQL provides three common set union arrays, nested tables, and variable-length arrays, PL/SQL provides corresponding functions or procedures for operation.
Element or subscript in the vertical array. These functions or procedures are called set
Grammar:identifier [CONSTANT] datatype [not NULL] [: = | DEFAULT Expr]Identifier: Used to specify the name of a variable or constant.CONSTANT: Used to specify constants. When you define a constant, you must specify its initial value, and its value
1) classification of Sets
Oracle supports three types of collections:
Associative array (Index-by table)
Nested table)
Variable-length array (VARRAY)
One of their differences is that the Nested table and VARRY can be used either in PL/SQL or
3.2. Compound Variables
Composite variables are used to store multiple values. When you define a composite variable, you must use the PL/SQL Composite data type.PL/SQL includes PL/SQL records, PL/SQL tables, nested tables, and varray.
2. PL/SQL
The PL/SQL programming language provides a data structure called Varray, which stores a constant-sized contiguous set of elements of the same type. Varray is used to store an ordered collection of data, but it is often more useful to think of an
It is recommended that you use an array when working with objects. But there may be problems when you need to use a large array in a dataset. For example, when a large array of ODAC is created for a field, a large number of Tfield fields are also
Variable introduction when writing a PL/SQL program, you can define variables and constants, including: 1 in a PL/SQL program, scalar type (scalar) 2), composite type (composite)--for manipulating a single record 3), reference type (reference)--
First, Variable introductionWhen you write a PL/SQL program, you can define variables and constants, including the following in the PL/SQL program:1), scalar type (scalar)2), composite type (composite) --for manipulating individual records3),
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.