Details
-
New Feature
-
Status: Open (View Workflow)
-
Major
-
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
-
- Needs Feedback
-
- links to
Activity
Field | Original Value | New Value |
---|---|---|
Link | This issue is part of MDEV-35973 [ MDEV-35973 ] |
Link | This issue relates to MDEV-32670 [ MDEV-32670 ] |
Link | This issue relates to MDEV-34319 [ MDEV-34319 ] |
Labels | Compatibility Oracle |
Remote Link | This issue links to "Nested tables in Oracle docs (Web Link)" [ 37331 ] |
Remote Link | This issue links to "Nested tables in Oracle docs (Web Link)" [ 37332 ] |
Parent | MDEV-35973 [ 132608 ] | |
Issue Type | New Feature [ 2 ] | Technical task [ 7 ] |
Link | This issue is part of MDEV-35973 [ MDEV-35973 ] |
Link | This issue is part of MDEV-35973 [ MDEV-35973 ] |
Parent | MDEV-35973 [ 132608 ] | |
Issue Type | Technical task [ 7 ] | New Feature [ 2 ] |
Priority | Major [ 3 ] | Minor [ 4 ] |
Priority | Minor [ 4 ] | Major [ 3 ] |