Oracle Interview Question - oracle %rowtype and %type

Oracle Interview Question - oracle %rowtype and %type
What is %rowtype?
What is %type?
what is the Differance between %rowtype and %type?
What is the advantage of using %rowtype and %type?

[ruda]

Sir, your way of logically explaining concepts is best.... simplifies so much🙏

[rajarshibose]

Hi Sir,
I just wanted to say you thank you from the bottom of my heart.
I had few confusions on some basic as well as advanced level concepts of pl/sql.
I am currently working in tcs having 2.11 years experience and I was planning to switch for a long time now.
After preparing from your videos, I have cracked the interviews of cognizant, infosys and accenture.
I am planning to sit on other companies as well.
Thanks a lot Sir !
The way you explained such hard concepts so easily is truly phenomenal.

[seethalakshmiadiga]

Very simplified way .. I am understanding basics. Thanks a lot ..Hats off to u ..

[panchamdwivedi]

I was asked the same question in an interview.

U have explained very well. Thank you

[manikumar]

sir thankyou i have clarified my doubt by watching this video

[debashisjena]

Sir your channel is just wow!!!👍👍 Love u from odisha

[deepanjanmallick]

If we are using %type....Which all things will be inherit ? Along with datatype if constraints will also inherit?

[Cheveuxes]

thank you now i understand what was the purpose of rowtype

[traptyjain]

Hi sir, your video is really very helpful.
I have a doubt, is %rowtype variable useful for for loop cursor?. Because we have looping variable which holds one record inside the loop.

[priyakoli]

Hi Sir,
Thank you for your explanation! Its really helpful.
I am a Java Developer but not hands on Plsql or oracle queries, so i just wanted to know what be the actual/ real time scenario when you need to use such attributes. I understood the concept but why to use this and what are the practical applications of it, in which area it will help me?

[ilangovankaliannan]

Hi Sir
Your videos are very nice. Thanks for posting it.
In your cursor with %rowtype example, why only one record got printed. I don't see you have used any where condition. Please clarify on what basis, one record got printed

Thanks

[sushkiduniya]

Could you plz wrote the syntax of oracle plsql for this one ... to understand it for beginners... plz reply asap

[bipinairee]

I have a question as you told in video if we  declare a variable  as % type and  we modify the  column datatype in a table so the declared variable datatype will be change same as table column datatype.But if i declare a variable as %rowtype and changes happens in table column and columns .so that variable of %rowtype datatype also change or what will happen on that case?

[santhoshkumar-qgos]

Hi sir 1 doubt, %rowtype will return only 1 record, so if we use that in cursor by giving loop while fetching whether it will return all data till fetch fails or it how it would work.

[sukritihazra]

Sir doyou have any note regarding %rowtype?

[kumark]

You have not used WHERE clause when you create CURSOR.... But how only one record fetched from the EMP table?? And how you got only that specific row even though you have not mentioned WHERE clause??

[peramsudheerreddy]

Bro please do one video about sub queries

[saikumarsuravarapu]

difference between type and % type in oracle please make video

[sridhartamilselvan]

Hi sir, if cursor C1 will return 1000 records (rows) . How can I print it one by one by using %Rowtype... Or pls post video for printing multiple records by using cursor. Thank you...