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

Author: Manish Sharma

Comments

January 16, 2019 at 3:07 am

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

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

January 16, 2019 at 8:45 am

Marain Nur says:

You are the best!!

January 16, 2019 at 5:59 pm

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

January 16, 2019 at 9:37 pm

Vignesh Chinna says:

Thank u

January 17, 2019 at 9:52 am

Hailay Mekonnen says:

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

January 17, 2019 at 11:12 pm

rachid nasri says:

i need the song in the background its keeling me

January 18, 2019 at 6:46 am

Raj Vizag says:

Great Job Manish!!!

January 18, 2019 at 7:41 pm

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

January 19, 2019 at 7:41 am

Kanika Gupta says:

why we use nested table?

January 19, 2019 at 12:29 pm

harman bawa says:

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

January 19, 2019 at 11:53 pm

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

January 20, 2019 at 12:31 am

Cutipiees says:

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