PL/SQL tutorial 52: How To Create Nested table as Database Object presents PL/SQL Tutorial on How To Create permanent Nested Table Type Collection based on primitive datatype in Oracle Database by Manish Sharma
Blog :
Previous Tutorial
► Nested table in PL/SQL Block

►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

___Facebook Official Page of Manish Sharma___

___Facebook Official Page of RebellionRider.com___

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


Hasnain Haider says:

Sir can you give me gmail address.I want to chat with you about oracle certification exams issues.

masum khan says:

Dear, I’d like to request you to make detailed videos on Schema Level Object Types.

Albert Alan says:

Sir.. Please cut the music behind.. It is distracting.. Otherwise it is superb.. Great job.

Cesar Navarro says:


Grs Raja says:

Dear Sir, could you please provide a link to know the benefit s of nested table…

naga babu podili says:

select * from b1

ERROR at line 1:
ORA-00600: internal error code, arguments: [qknsiExplain-obj], [93435], [], [], [], [], [], [], [],
[], [], []

I Create nested table using database objects , and i assigned it to the while creating the table ,and after that i inserted the rows in it ,and that success in row inserted ,while i am trying to retrive it giving the above mentioned error i.e ORA-00600 can any one could solve this error.

Hasnain Haider says:

Thank you Sir.

Debadatta Beura says:

Thank you very much sir for your concept you have the best concept i ever learn from anyone.keep it up sir


really excellent Manish Sharma, Your teaching skills are ultimate. Can you please help to create form in Oracle data base or SQL data base.

creative studio says:

make a video on how to drop database in oracle 11 g

cwg says:

Thank you, very much for this. I tried to understand this topic in a number of ways but your examples have been the best.

As far as an opinion on this, I can’t think of a use case and my toes curl at the idea of anyone doing this to a database. I’m a bit of a classicist though so my cringe reaction shouldn’t be trusted. I’d have to see a production use case to have an informed opinion.

P.S. I like the music in the typing interludes.


HI Manish,
Please tell me the question’s answer which was asked on this video as i was unable to find out the right answer.
Question: If we shouldn’t have multiple values in a column then why NESTED TABLES?
Please tell Sir, I am waiting for your response.

Prakash says:

I can see your hard work behind this video
excellent! keep it up

Jesus Miguel says:

Amazing, you blow my mind.. thanks.


Hi sir , my name is SALEH and I am from UAE .. I came all the way from Abu Dhabi to Bangalore for BCA and to tell you that I am a huge fan of yours ; you made me love database ‘oracle’ in particular ; I hope you continue doing this great job and I really learned a lot from you ; thank you sir may god bless you

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