RebellionRider.com presents PL/SQL Tutorial on How To Create permanent Nested Table Type Collection based on primitive datatype in Oracle Database by Manish Sharma
————————————————————————
►►►LINKS◄◄◄
Blog : http://bit.ly/nested-table
Previous Tutorial
► Nested table in PL/SQL Block https://youtu.be/EUYyiFCzU0I
————————————————————————-
►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
https://twitter.com/rebellionrider
http://instagram.com/rebellionrider
https://plus.google.com/+Rebellionrider
http://in.linkedin.com/in/mannbhardwaj/
___Facebook Official Page of Manish Sharma___
https://www.facebook.com/TheRebellionRider/
___Facebook Official Page of RebellionRider.com___
https://www.facebook.com/RebellionRider.official/
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
This is Manish from RebellionRider.com
♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Amazon Auto Links: No products found.
Sir can you give me gmail address.I want to chat with you about oracle certification exams issues.
Dear, I’d like to request you to make detailed videos on Schema Level Object Types.
Sir.. Please cut the music behind.. It is distracting.. Otherwise it is superb.. Great job.
Great!!!!!
Dear Sir, could you please provide a link to know the benefit s of nested table…
select * from b1
ERROR at line 1:
ORA-00600: internal error code, arguments: [qknsiExplain-obj], [93435], [], [], [], [], [], [], [],
[], [], []
I Create nested table using database objects , and i assigned it to the while creating the table ,and after that i inserted the rows in it ,and that success in row inserted ,while i am trying to retrive it giving the above mentioned error i.e ORA-00600 can any one could solve this error.
Thank you Sir.
Thank you very much sir for your concept you have the best concept i ever learn from anyone.keep it up sir
really excellent Manish Sharma, Your teaching skills are ultimate. Can you please help to create form in Oracle data base or SQL data base.
make a video on how to drop database in oracle 11 g
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.
HI Manish,
Please tell me the question’s answer which was asked on this video as i was unable to find out the right answer.
Question: If we shouldn’t have multiple values in a column then why NESTED TABLES?
Please tell Sir, I am waiting for your response.
Thanks,
Bikash
I can see your hard work behind this video
excellent! keep it up
Amazing, you blow my mind.. thanks.
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