Oracle
1Z0-146 · Question #136
View the Exhibit and examine the code in the PL/SQL block. The PL/SQL block generates an error on execution. What is the reason?
The correct answer is A. The DELETE(n) method cannot be used with varrays. Varrays are dense, so you cannot delete their individual elements.
Advanced PL/SQL Features
Question
View the Exhibit and examine the code in the PL/SQL block. The PL/SQL block generates an error on execution. What is the reason?
Exhibit
Options
- AThe DELETE(n) method cannot be used with varrays.
- BThe DELETE(n) method cannot be used with nested tables.
- CThe NEXT method cannot be used with an associative array with VARCHAR2 key values.
- DThe NEXT method cannot be used with a nested table from which an element has been deleted.
How the community answered
(55 responses)- A84% (46)
- B2% (1)
- C5% (3)
- D9% (5)
Explanation
Varrays are dense, so you cannot delete their individual elements.
Topics
#collection methods#DELETE method#varray#nested table
Community Discussion
No community discussion yet for this question.
