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.
@@pranaykukadkar7092 prepare on concepts like triggers, exceptions Collections like varray, associated array, nested tables Cursors 1.strongly typed 2.weakly typed Mutating table errors That should cover most of it And also prepare type of joins
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.
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?
%type is used in most of the places, real time usage is , you dont have to bother even if the underlying data type changes, it will be automatically taken care by %type. Similarly, any new column addition or removal will be automatically taken care my %rowtype
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??
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?
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
@Illango, Cursor retrieve one record per fetch operation, I have explained about cursor in this video, ruclips.net/video/X7WFuI5eTX4/видео.html Please look into this, i am sure, this video will answer your question. Thanks, Siva
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.
Hi Santosh, variable defined as %rowtype, will hold one record of table ( defined as %rowtype), hence in cursor, for every iteration, we can save one record into rowtype variable
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...
@Sridhar, Ya, I will post a video on this question ( + few other questions I have received ), so that It would be useful for every one, Please Stay tuned.
Sir, your way of logically explaining concepts is best.... simplifies so much🙏
My pleasure thank you 💐
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.
Thank you bro, Best wishes 🙏🙏👍👍💐💐
Hi bro, tomorrow is my interview on PLSQL Can you please help me with Q&A which they asked you ??
@@pranaykukadkar7092 prepare on concepts like triggers, exceptions
Collections like varray, associated array, nested tables
Cursors
1.strongly typed
2.weakly typed
Mutating table errors
That should cover most of it
And also prepare type of joins
@@rajarshibose4454 thank you bro
Very simplified way .. I am understanding basics. Thanks a lot ..Hats off to u ..
Welcome bro
If we are using %type....Which all things will be inherit ? Along with datatype if constraints will also inherit?
I was asked the same question in an interview.
U have explained very well. Thank you
Welcome bro
sir thankyou i have clarified my doubt by watching this video
Sir your channel is just wow!!!👍👍 Love u from odisha
Welcome bro
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.
Thank you for very good explanation
@prasanth, thanks for your comments bro 🙏
Could you plz wrote the syntax of oracle plsql for this one ... to understand it for beginners... plz reply asap
Sir doyou have any note regarding %rowtype?
Sir u r great 🙏
Thank you
VEry well explained, thanks.
Welcome
thank you now i understand what was the purpose of rowtype
Welcome
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?
%type is used in most of the places, real time usage is , you dont have to bother even if the underlying data type changes, it will be automatically taken care by %type.
Similarly, any new column addition or removal will be automatically taken care my %rowtype
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??
All the rows got fetched into the cursor but the thing is sir has not used any loop so only the first record was accessible
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?
Yes it will be handled
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
@Illango, Cursor retrieve one record per fetch operation, I have explained about cursor in this video,
ruclips.net/video/X7WFuI5eTX4/видео.html
Please look into this, i am sure, this video will answer your question.
Thanks,
Siva
dear ilangovan
%rowtype fetches only one row it shows first row..to print all records row by row loop is used.
Hello Thank you nice explanation🙏😊
Welcome 🙏💐
Thanks a lot bro
Welcome bro
Hi ,please say about mongodb
Sure, please stay tuned
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.
Hi Santosh, variable defined as %rowtype, will hold one record of table ( defined as %rowtype), hence in cursor, for every iteration, we can save one record into rowtype variable
AWESOME
Welcome bro
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...
@Sridhar, Ya, I will post a video on this question ( + few other questions I have received ), so that It would be useful for every one, Please Stay tuned.
hi sridhar
please use loop which will print one by one record
use loop
difference between type and % type in oracle please make video
Sure, Please stay tuned, i will post on type vs %type
Bro please do one video about sub queries
Video no 34 to 37
ruclips.net/video/Ylm2f7tSAu0/видео.html
Sir Please speak little bit loudly
Sure bro, I hope the recent videos are fine
SQL query tuning sir
@kathir, sure will post these topics as part of performance tuning video series, please stay tuned