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

[@ursus9104]

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

[@smoshabi]

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

[@Rebellionrider]

I'm glad you found my video helpful 😊

[@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

[@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')));

[@anisiahgrace2160]

love your videos🥰

[@Rebellionrider]

Thank you so much

[@anisiahgrace2160]

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

[@sanjeevashoka7948]

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.

[@capitalentertainment1314]

THANK YOU FOR TUTORIALS, MAKE REMAINING CONCEPTS OF COLLECTIONS.

[@shashank2004]

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

[@gauravkadam9197]

Thanks for making this tutorial !

[@spandanalakkakula6706]

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).

[@zakirhossen4713]

thank you for tutorial series and sequence maintain

[@ashwikraoalladi3320]

good back ground music

[@harmanbawa19]

thanks sir!

[@judensah3972]

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

[@rafiulhassan4027]

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

[@harikrishnan5187]

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

[@mathankumar2228]

same plm.. did u inserted?

[@KulamaniMuduli]

How to retrieve multiple records after inserting them ?

[@mayankjain6891]

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

[@sameerahmad7592]

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 ..

[@mariogoren]

I cant also :(

[@vidyalakshmiprabhu7805]

See his blog he has said about how to retrieve

[@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. 00000 - "missing comma"
*Cause:
*Action:

[@khaledelolemy7853]

if you're still wondering, it's a right parenthesis missing not comma.

[@AbdulHanan-xk6hf]

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

[@Rebellionrider]

Just replied your mail.

[@AbdulHanan-xk6hf]

​@@Rebellionrider thank u for response mail kindly read the comment I specify problem
love from pakistan

[@knandi73]

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. 😊

[@Rebellionrider]

I realized this thing and I stopped putting the music. I apologize for the inconvenience

[@knandi73]

@@Rebellionrider thank you

[@AbdulHanan-xk6hf]

​
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. 00000 - "%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. 00000 - "name is already used by an existing object"
thank you for responce love from Pakistan

[@Rebellionrider]

Hey Abdul... Firstly what is the error which you are getting on deleting the table... Second check if you have created any trigger which is preventing your operations.

[@AbdulHanan-xk6hf]

@@Rebellionrider
drop table "HR"."BASE" cascade constraints PURGE
Error report -
ORA-00600: internal error code, arguments: [15265], [], [], [], [], [], [], [], [], [], [], []
00600. 00000 - "internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s]"
*Cause: This is the generic internal error number for Oracle program
exceptions. It indicates that a process has encountered a low-level,
unexpected condition. The first argument is the internal message
number. This argument and the database version number are critical in
identifying the root cause and the potential impact to your system.