Details
-
New Feature
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
None
Description
A nested table in is a dynamic, array-like data structure that allows you to store multiple elements of the same data type in a single variable.
Methods (TODO: add details):
- COUNT
- DELETE
- EXISTS
- EXTEND
- FIRST
- LAST
- index
- LIMIT
- NEXT
- PRIOR
- TRIM
Example:
DECLARE
|
TYPE NameList IS TABLE OF VARCHAR2(10); |
|
names NameList := NameList('John', 'Paul', 'Jorge'); |
|
PROCEDURE print_names IS |
BEGIN |
DBMS_OUTPUT.PUT_LINE(names.COUNT || ' values:'); |
FOR i IN names.FIRST .. names.LAST LOOP |
DBMS_OUTPUT.PUT_LINE(names(i));
|
END LOOP; |
DBMS_OUTPUT.PUT_LINE('---'); |
END; |
|
BEGIN |
print_names();
|
|
names(3) := 'Ringo'; |
print_names();
|
|
names.extend(1);
|
names(4) := 'Jorge'; |
print_names();
|
|
names := NameList('Chuck', 'Bruce'); |
print_names();
|
END; |
3 values:
|
John
|
Paul
|
Jorge
|
---
|
3 values:
|
John
|
Paul
|
Ringo
|
---
|
4 values:
|
John
|
Paul
|
Ringo
|
Jorge
|
---
|
2 values:
|
Chuck
|
Bruce
|
---
|
Attachments
Issue Links
- is part of
-
MDEV-35973 Oracle Compatibility Project 1 for 2025
-
- In Progress
-
- relates to
-
MDEV-32670 VARRAY for scalar data types
-
- Open
-
-
MDEV-34319 Associative arrays: DECLARE TYPE .. TABLE OF .. INDEX BY in stored routines
-
- In Review
-
- links to