HomeОбразованиеRelated VideosMore From: Manish Sharma

PL/SQL tutorial 51: How To Create Nested Table collection in PL/SQL Block

209 ratings | 23421 views
RebellionRider presents PL/SQL tutorial 51 on how to create a Nested table in Oracle Database by Manish Sharma ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/nested-table-1 Previous Tutorial ► For Loop: https://youtu.be/DfAmnj2j7WI ------------------------------------------------------------------------- ►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
Html code for embedding videos on your blog
Text Comments (14)
Kanika Gupta (2 months ago)
why we use nested table?
Vignesh Chinna (6 months ago)
Thank u
The most laconic and understandable tutorials. Thank you, Manish!
rachid nasri (7 months ago)
i need the song in the background its keeling me
harman bawa (9 months ago)
is it Declare or Declre??? in ur video its mentioned as DECLRE!!
Cutipiees (9 months ago)
Hi Manish , I tried : declare TYPE my_nested IS TABLE OF NUMBER; var_nt my_nested := my_nested(23,474,45,97,747,58,55); BEGIN var_nt.DELETE(4); FOR i in 1.. var_nt.count Loop dbms_output.put_line( 'Value store at index: '||i||' is '||var_nt(i)); End Loop; Exception WHEN no_data_found THEN dbms_output.put_line( 'Data had been deleted on my_nested table'); END; / Output: Value store at index: 1 is 23 Value store at index: 2 is 474 Value store at index: 3 is 45 Data had been deleted on my_nested table
Cutipiees (9 months ago)
Hi Manish, Thanks for nice video. Could you please make one video on how to delete the nested table any arbitrary data.
venktesh dwivedi (1 year ago)
Hi Manish Thanks for providing wonderful pl sql course for us , you really made oracle easy for us. One think that i like about you as compared to other youtubers that you provide Good amount of knowledge in very short video . God Bless you
Hailay Mekonnen (1 year ago)
hello, dear Manish, can you answer the question 'why nested table' by yourself?
Robert Bhandari (1 year ago)
They are useful whenever we want to store multiple instances of data against which we want to do the same thing. The classic example is using BULK COLLECT to store multiple records: select * bulk collect into emp_rec_nt from employees;
Marain Nur (1 year ago)
You are the best!!
Raj Vizag (1 year ago)
Great Job Manish!!!
Bikash Sharma (1 year ago)
why not open my HR connection when i open my hr connection then display message your account is locked please help me
Vignesh Chinna (6 months ago)
Bikash Sharma Ur account need to unlock go sqlplus type Conn / as sysdba; Alter user Hr unlock;

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.