PL/SQL tutorial 52: How To Create Nested table as Database Object by Manish Sharma

------------------------------------------------------------------------
►►►LINKS◄◄◄
Previous Tutorial

-------------------------------------------------------------------------
►Make sure you SUBSCRIBE and be the 1st one to see my videos!
-------------------------------------------------------------------------
►►►Find me on Social Media◄◄◄
Follow What I am up to as it happens on

___Facebook Official Page of Manish Sharma___

You can also Email me at
for E-mail address please check the About section

Please please LIKE and SHARE my videos it makes me happy.
Thanks for liking, commenting, sharing and watching more of our videos

♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS

[salehgumaan]

Hi sir, my name is SALEH and I am from UAE .. I came all the way from Abu Dhabi to Bangalore for BCA and to tell you that I am a huge fan of yours ; you made me love database 'oracle' in particular ; I hope you continue doing this great job and I really learned a lot from you ; thank you sir may god bless you

[priyankaingole]

Hey Manish, the background music is cool, it keeps you in good mood :) . Great and to the point explanation.

[hadoopwithcp]

I can see your hard work behind this video
excellent! keep it up

[pankajrao]

Thank you very much for the simplified explanation

[juststudies]

I finaly understood nested tables THANK YOU SO MUCH ! <3

[debadattabeura]

Thank you very much sir for your concept you have the best concept i ever learn from anyone.keep it up sir

[likithagunda]

Not even a single dislike..That is Manish..!!!

[georgiafox]

Thank you! This was very helpful. I really like your videos.

[lalitpatil]

Hi Manish, Thanks for very short yet all content covered kind of videos, it clears the concept.
Real time example of Nested table could be used where Set of values is not fixed, container 1x - A, B, C items and container 2x - A, B, C, D, E, F, G, H items. Being unbounded and variable size Nested Tables are useful in such kind of DB structure requirements.

Request you to comment on my understanding and 1 NF multiple values VS Nested table (array with multiple values) in same tuple

[jeanahollings]

Thank you, very much for this. I tried to understand this topic in a number of ways but your examples have been the best.

As far as an opinion on this, I can't think of a use case and my toes curl at the idea of anyone doing this to a database. I'm a bit of a classicist though so my cringe reaction shouldn't be trusted. I'd have to see a production use case to have an informed opinion.

P.S. I like the music in the typing interludes.

[gunjanbrijwani]

Hi Manish,
Thanks for the video.
Can you please tell me what is the structure of the out-of-line table, i.e., the table in which nested table data is stored?

[NTICTECH]

i'm from Morocco and i love you men

[MasumsLanguageITZone]

Dear, I'd like to request you to make detailed videos on Schema Level Object Types.

[etaxfiling]

really excellent Manish Sharma, Your teaching skills are ultimate. Can you please help to create form in Oracle data base or SQL data base.

[kolapuri]

Answer to your question: We have requirement of storing multiple values in a column just like address, correct me If I am wrong.

[Shakirusman]

Dear sir, We use nested tables for multivalued attribute. Am I right sir..
And thanks a lot sir from Pakistan, you are genius . May you live long

[kolapuri]

Hi Sir, if we add subjects column to the students table then we find the difference as each student have multiple subjects and number of subjects also varies by the students, in such case nested tables are very useful. I think I am right. Any how thanks for your tutorials I learnd lot from you.

[vinayreddy]

Hi Manish,
When i try to fetch the data using subquery it's throwing an error even when i update also like the way you mentioned in the blog

[milindchopde]

Hi, your videos are superb...can you please tell me in which case I should use nested table and index by table? It will be really helpful in real time environment.

[AjayKumar-igwn]

hi maneesh, i created same table while creating nested table db object i taken number after inserting a row i got an error [unsupported data type]