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

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

278 ratings | 30027 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 (8 months ago)
why we use nested table?
Vignesh Chinna (1 year ago)
Thank u
The most laconic and understandable tutorials. Thank you, Manish!
rachid nasri (1 year ago)
i need the song in the background its keeling me
harman bawa (1 year ago)
is it Declare or Declre??? in ur video its mentioned as DECLRE!!
Cutipiees (1 year 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 (1 year 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 (2 years 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 (2 years ago)
You are the best!!
Raj Vizag (2 years ago)
Great Job Manish!!!
Bikash Sharma (2 years 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 (1 year 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.