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

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

Comments

Даниил Зайцев says:

The most laconic and understandable tutorials. Thank you, Manish!

Marain Nur says:

You are the best!!

Cutipiees says:

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

Vignesh Chinna says:

Thank u

Hailay Mekonnen says:

hello, dear Manish, can you answer the question ‘why nested table’ by yourself?

rachid nasri says:

i need the song in the background its keeling me

Raj Vizag says:

Great Job Manish!!!

Bikash Sharma says:

why not open my HR connection when i open my hr connection then display message your account is locked please help me

Kanika Gupta says:

why we use nested table?

harman bawa says:

is it Declare or Declre??? in ur video its mentioned as DECLRE!!

venktesh dwivedi says:

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

Cutipiees says:

Hi Manish,
Thanks for nice video. Could you please make one video on how to delete the nested table any arbitrary data.

 Write a comment

*

Do you like our videos?
Do you want to see more like that?

Please click below to support us on Facebook!