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

*

Human Verification: In order to verify that you are a human and not a spam bot, please enter the answer into the following box below based on the instructions contained in the graphic.


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

Please click below to support us on Facebook!

Send this to a friend

▷ Other ReviewsVehicles   Show Cars   Motorbikes   Scooters   Bicycles   Rims & Tires   Luxury BoatsFashion   Sunglasses   Luxury Watches   Luxury Purses   Jeans Wear   High Heels   Kinis Swimwear   Perfumes   Jewellery   Cosmetics   Shaving Helpers   Fashion Hats   Modeling TipsFooding   Chef Club   Fooding Helpers   Coktails & LiquorsSports   Sport Shoes   Fitness & Detox   Golf Gear   Racquets   Hiking & Trek Gear   Diving Equipment   Ski Gear   Snowboards   Surf Boards   Rollers & SkatesEntertainment   DIY Guides   Zik Instruments   Published Books   Music Albums   Cine Movies   Trading Helpers   Make Money   Fishing Equipment   Paintball Supplies   Trading Card Games   Telescopes   Knives   Vapes   GameplaysHigh Tech   Flat Screens   Tech Devices   Camera Lenses   Audio HiFi   Printers   USB Devices   PC Hardware   Network Gear   Cloud Servers   Software Helpers   Programmer Helpers   Mobile Apps   Hearing AidsHome   Home Furniture   Home Appliances   Tools Workshop   Beddings   Floor Layings   Barbecues   Aquarium Gear   Safe Boxes   Office Supplies   Security Locks   Cleaning ProductsKids   Baby Strollers   Child Car Seats   Remote ControlledTravel   Luggages & Bags   Airlines Seats   Hotel Rooms   Fun Trips   Cruise Ships   Mexico Tours