I often see questions on technical forums about arrays in PL/SQL, which type to use and what the differences are.
Although the documentation has quite a lot to
say on the subject, I personally think it tries to introduce too many concepts at once and ends up
being confusing, especially when it comes to choosing between VARRAYs and Nested Table collections, where most of the "which to use"
advice is about collection columns of database tables (which you probably don't need), and not about PL/SQL at all.
The documentation may give the impression that "array" means "VARRAY", without mentioning the limitations of VARRAYs. This could be one
reason why I often see VARRAYs used where Nested Table collections would have been a better choice.
This article therefore sets out what I consider the main points of each type, from the point of view of a PL/SQL programmer.
0 Comments:
Post a Comment
Links to this post:
Create a Link
<< Index of articles