Hi, I really like the way you teach. I have a doubt though, Why didn't you EXTEND() the parent variable before it gets values from MULTISET operation? As for the other variables you extended them first and did assigned later. My understanding is that the NESTED variables needs to be extended before they can be actually initialized with values. I'm not sure if i'm correct.
You do not need to extend when you populate a nested table or varray with a bulk collect operation or the multiset operations. Since there is no way to know the number of rows, this is a very handy feature, isn't it?
Hi Steve, thanks for this awesome video. I have a doubt. How to retrieve records in a table based on the values in Nested table. That is, some value from nested table will appear in the WHERE clause.
Thanks, Rushikesh. Suppose your nested table is l_names and it has a value in the 3rd index. Then your where clause might look like "WHERE last_name = l_names(3)". Or is that NOT your question?
+Abhilash Raiguru I will add it my list Abhilash. In the meantime, check out my blog posts on the topic: stevenfeuersteinonplsql.blogspot.com/2015/04/table-functions-introduction-and.html
Perfect illustration!
Thank you for all these great videos!
You are very welcome.
Thanks a lot sir🙏 subscribed
Please explain the detail on 15:21, why you set the NESTED TABLE children_names STORE AS parent_names_tbl? Why the swap? Thank you sir.
Hi, I really like the way you teach. I have a doubt though, Why didn't you EXTEND() the parent variable before it gets values from MULTISET operation? As for the other variables you extended them first and did assigned later. My understanding is that the NESTED variables needs to be extended before they can be actually initialized with values. I'm not sure if i'm correct.
You do not need to extend when you populate a nested table or varray with a bulk collect operation or the multiset operations. Since there is no way to know the number of rows, this is a very handy feature, isn't it?
Hi Steve, thanks for this awesome video. I have a doubt. How to retrieve records in a table based on the values in Nested table. That is, some value from nested table will appear in the WHERE clause.
Thanks, Rushikesh. Suppose your nested table is l_names and it has a value in the 3rd index. Then your where clause might look like "WHERE last_name = l_names(3)". Or is that NOT your question?
hi Steven, can you make a video about pipelined table functions
+Abhilash Raiguru I will add it my list Abhilash. In the meantime, check out my blog posts on the topic: stevenfeuersteinonplsql.blogspot.com/2015/04/table-functions-introduction-and.html
+Practically Perfect PL/SQL with Steven Feuerstein thank you Steven