PL/SQL tutorial 53: How to create nested tables using user define datatype

------------------------------------------------------------------------
►►►LINKS◄◄◄
Previous Tutorial

-------------------------------------------------------------------------
►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___

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

♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS

[ursus]

Mr. you are an excellent teacher, best I ever had.

[smoshabi]

EXCELLENT !!!! Exactly what I need for my ORDBMS assignment

[SwetlanaKM]

Thank you so much sir!! i had no idea about this topic but coincidently i clicked on your video and found it intriguing ....because of you i can add this topic to my resume ....God bless you sir

[anisiahgrace]

Hi
this is an excellent thank you and appreciate what you do.

[capitalentertainment]

THANK YOU FOR TUTORIALS, MAKE REMAINING CONCEPTS OF COLLECTIONS.

[zakirhossen]

thank you for tutorial series and sequence maintain

[MotoExploring]

The right code to insert is this one
INSERT INTO base_table (tab_id, tab_ele) VALUES
(801, My_NT(object_type (1, 'Superman')));

[shashank]

Awsome video, PL make a video on object type and their member function

[sanjeevashoka]

First of all Thanks a lot Sir for such tutorials. Sir, I visited your blog for every video for depth knowledge as u say in the tutorials. I visited to blog for this video also for the insertion.

insert into base_table values(801,
my_tab(object_type(1, 'superman'), (2, 'batman')
)
);
I did according to the way you provided on the blog, Why this is giving an error?
Please help me ASAP.

[spandanalakkakula]

Hi...Very helpful.Thank you.
I have a doubt.
Collection generally stores values of same datatype, then how can we use Object type as datatype for creating nested tables which can have multiple datatypes ( In the example of video, it has two datatypes number and varchar2).

[mayankjain]

Hi Manish ...getting error SQL Error: ORA-00932: inconsistent datatypes: expected UDT got CHAR while inserting data into base_table .. could you plese advise

[KulamaniMuduli]

How to retrieve multiple records after inserting them ?

[judensah]

Please sir, how do I insert data into the user defined data type table?

[rafiulhassan]

sir can you please make a tutorial about how to create a new user in oracle 12c and connect the user to the netbeans IDE using jdbc

[harikrishnan]

Can i get the video how to insert values in a table for user defined datatypes

[sameerahmad]

Hello Mr.Manish, I am unable to insert value into the table. Its giving me the error - "SQL Error: ORA-00932: inconsistent datatypes: expected UDT got NUMBER".
Kindly help ..

[claudiotti]

Hi. show errors.
INSERT INTO base_table (tab_id, tab_ele) VALUES
(801, My_NT (object_type (1, 'Superman') )
Error en la línea de comandos : 52 Columna : 44
Informe de error -
Error SQL: ORA-00917: missing comma
00917. - "missing comma"
*Cause:
*Action:

[AbdulHanan-xkhf]

am getting error( ORA-00600 )
please sir check your mail

[AbdulHanan-xkhf]

​
CREATE TABLE my_subject (
sub_id NUMBER,

sub_name VARCHAR2(20),

sub_schedule_day my_nested_table
) NESTED TABLE sub_schedule_day STORE AS nested_tab_space;


first time when i run the code work correct but 2nd time
1 ---> sir I am unable to drop table ( my_subject ) when i try to drop error occur and user=hr automatically sing out
2---> And when i try to insert any row got an error ORA-00904: "SUB_SCHEDULE_DAY": invalid identifier
00904. - "%s: invalid identifier"

3--> when i run the whole statment i got an error ORA-00955: name is already used by an existing object
00955. - "name is already used by an existing object"






thank you for responce love from Pakistan

[knandi]

Please do not add any kind of background music. It's very much irritating and hampers the concentration level. It's the place to learn, not to dance at music. 😊