Trying To Understand PL-SQL Concept
Dear Experts,
I'm teaching myself PL-SQL however im stuck at this concept of 2D collections, I'm following all examples on the Oracle® Database PL/SQL Language Reference 11g release 2 (11.2), however i'm having a hard time trying to wrap my head around this 2D exercise. I dont have any formal programming experience but i'm trying to learn it myself. If someone can look at the PDF attached and explain to me what sort of structure it's making and how it's assigning values to the NVA collection, id trully appreciate it. With this understanding i can further my knowledge on collections.
Thanks for your patience and insight.
Oracle-PL-SQL-Trying-To-Understa.pdf
I'm teaching myself PL-SQL however im stuck at this concept of 2D collections, I'm following all examples on the Oracle® Database PL/SQL Language Reference 11g release 2 (11.2), however i'm having a hard time trying to wrap my head around this 2D exercise. I dont have any formal programming experience but i'm trying to learn it myself. If someone can look at the PDF attached and explain to me what sort of structure it's making and how it's assigning values to the NVA collection, id trully appreciate it. With this understanding i can further my knowledge on collections.
Thanks for your patience and insight.
Oracle-PL-SQL-Trying-To-Understa.pdf
To try and put it in laymans terms: A drawer in a filing cabinet.
A folder stores 1 to many pieces of paper. t1 is a folder.
va creates a new folder of type t1.
The drawer can store 1 to many folders. nt1 is a drawer.
nwa is a new drawer in your filing cabinet.
va has 3 pieces of paper: 2,3,5.
nwa has 4 folders: the original va and two new ones: a folder with 3 papers (55,6,73), a folder with 2 papers (2,3) and another folder that is a copy of the first va.
The extend code below creates a new folder in the drawer.
The offsets (5) and (4) are referencing specific folders in your drawer.
Two offsets (4)(4) refer to folder #4 and paper #4 in that folder.
A folder stores 1 to many pieces of paper. t1 is a folder.
va creates a new folder of type t1.
The drawer can store 1 to many folders. nt1 is a drawer.
nwa is a new drawer in your filing cabinet.
va has 3 pieces of paper: 2,3,5.
nwa has 4 folders: the original va and two new ones: a folder with 3 papers (55,6,73), a folder with 2 papers (2,3) and another folder that is a copy of the first va.
The extend code below creates a new folder in the drawer.
The offsets (5) and (4) are referencing specific folders in your drawer.
Two offsets (4)(4) refer to folder #4 and paper #4 in that folder.
ASKER
Thank you much slightwv for the explanation i appreciate it, may i ask if there's a way you can visualize for me the nva structure, just a simple diagram will do, i just want to visualize it, is it similar to what i put on the pdf?
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
Thank you so much Slightwv i appreciate your time and effort explaining this to me. It cleared up alot for me.
Glad to help! We're here when you need us!!!
http://www.sqlsnippets.com/en/topic-12310.html