Thank you so much for explaining. As a part of merge , can we delete record on target table if there is no record on source table with the matching emp.id ?
Start - 0:08 0:54 - Now what we have to do is 1:35 - Subquery Update Statement 3:19 - Now what he is going to do 6:11 - Using Merge Statement 08:22 - Saari queries ek sath 10:06 - Delete krna h tohh 13:03 - One Imp Topic
Hi sir... Your way of explanation is so good.. I have one question regarding sql tuning.. If one select query is running 4 to 5 hrs.. How can you find issues in that select stmnt without going to execution plan
Very well explained. I am looking for ETL concepts and transformations explanation. Couldn't find in your videos. Are there any? Would be of great help if there are any
Learnt lot of concepts sir. I really admire your teaching. Please do videos on performance tuning indetail more. And also on nested loop, hash, merge joins pls.
Hello Siva,it was good video.i have a doubt and it was question too for me in an interview ,how general insert is different from merge what is the difference between them when to use what ,we can generally use insert into ,though it comes with three functionalities in one statement how it differs from previously existing insert,update.
thanks for ur valuable help to improve ourselves. I have a question that how to create a table using a mask means I want to insert a table value with the mask. ie means want an output like 4 digits first/last pad from the account number.
Both the table have all Column name same it's necessary condition ?or if I have only one Column name same both the table then also I will be apply merge statement ?
Hi Sir, I'm having one issue with merge statement, i wrote a merge state ment like below Merge into trgt_table t1 Using src_table t2 On (t1.id=t2.id) When matched then Update set t1.name=t2.name; But in my scenario there are multiple duplicate values are there in t1.id and t2.id columns because those are the referenced columns from another table. When i execute this script I'm getting error "Ora-30926 unable to get a stable set of rows in the source table" Can you please help me out on this query
Sir i have question Ipl table having team name and player name Mumbai rohit Mumbai pollard Mumbai boult Delhi dhawan Delhi rabada Result should be Mumbai delhi Rohit dhawan Pollard rabada Boult null Note : not using pivot function Answer here itself thanks
Hi Siva Garu, How to get Second Highest Average salary , Department wise ? Deptno Avg(Sal) 10 1566 20 2175 ---> I need to display this department(Second highest average salary ) 30 2916 Can you please share sql query for above question ?
![Kodak Black - Catch Fire [Official Music Video]](http://i.ytimg.com/vi/A4ch-olIuZo/mqdefault.jpg)
thanks for doing these kind of videos sir...because of this channel only i got a job ,learned lot of concepts ,keep it up Sir...@@@thank you
Its my pleasure, thanks for your comments, all the best 👍👍💐💐
Thank you so much for explaining. As a part of merge , can we delete record on target table if there is no record on source table with the matching emp.id ?
So much of efforts putting specially on oracle sql plsql videos .. you are very great man..thank you so much siva garu
Thank you very much 🙏🙏💐💐
Start - 0:08
0:54 - Now what we have to do is
1:35 - Subquery Update Statement
3:19 - Now what he is going to do
6:11 - Using Merge Statement
08:22 - Saari queries ek sath
10:06 - Delete krna h tohh
13:03 - One Imp Topic
Hi sir... Your way of explanation is so good.. I have one question regarding sql tuning.. If one select query is running 4 to 5 hrs.. How can you find issues in that select stmnt without going to execution plan
Very well explained. I am looking for ETL concepts and transformations explanation. Couldn't find in your videos. Are there any? Would be of great help if there are any
Thanks for making the concept clear !! 👍
Welcome 🙏💐
Superb explanation Siva, all videos are very informative and helpful 👍👍👌👌👌 thank you 🙏🏻
Thank you bro 💐
Super explanation sir. Thank you so much
Welcome bro
Very nice! I was using temp tables to accomplish this same task
Very nice video sir, thank u so much... God bless you 🙏😊🙏
My pleasure, thank you 💐🙏🙏🙏
Learnt lot of concepts sir. I really admire your teaching. Please do videos on performance tuning indetail more. And also on nested loop, hash, merge joins pls.
Thank you bro, sure please stay tuned, will add to upcoming videos
Ur explaination was awesome.
Thanks you 💐
Sir you are simply great we have 👍🙏
Thank you 🙏🙏🙏💐💐💐
Hello Siva,it was good video.i have a doubt and it was question too for me in an interview ,how general insert is different from merge
what is the difference between them when to use what ,we can generally use insert into ,though it comes with three functionalities in one statement how it differs from previously existing insert,update.
You are doing a great job. Do you conduct any online classes ? Will be glad to join it.
Thanks siva for detailed explanation. Can we update more than one row?
Yes Murali, you can, records that matches the join condition
this vedio help me to learn the marge statement ,so thanks for the same
Welcome bro 💐
superb Siva! very good explanation..
Thank you 🙏💐
thanks for ur valuable help to improve ourselves.
I have a question that how to create a table using a mask means I want to insert a table value with the mask. ie means want an output like 4 digits first/last pad from the account number.
Give me sample input and expected output please
Both the table have all Column name same it's necessary condition ?or if I have only one Column name same both the table then also I will be apply merge statement ?
Sir plz upload vedio forLIMIT clause and how to handle bulk exception
Sure, please stay tuned, next video in plsql performance tuning series is about handling exception in bulk collection, please stay tuned
Thank you...
Thank you soo mich sir....
Welcome bro
good explained
Thank you
will u explain same merge with using pl sql code???
hii Siva i need below ans with explanation
If same kind of logic we put in function as well as procedure then which one will be faster.
I dont think there will be much difference in execution
@@SivaAcademy bro can we have merge statement in procedures without using execute immediate.
Yes bro, you can have merge statement like any other dml statement inside procedure
Nice explanation, Thanks...
Welcome
Good....!
Thanks
Hi sir your videos are more informative.if it is possible please upload performance tuning videos tq sir
Sure please stay tuned
Is there any way to maintain the sort order in the MERGE INSERT operation?
Can you please give me sample data and expected output
Nice explaination sir
Thank you 💐
Can we insert records in 3rd table instead of Target table using Merge Statement with clause( When Not matched). Please advise.
I dont think to
Superb, excellebt vid..
Thank you 💐
Nice explanation...Sir...👍👍👍❤️❤️
Thank you bro 💐
Thank u shiva
Welcome bro 💐
What combinations can I use in merge statment?
Sir Can you please post some videos on Unix interview Question and answers
Sure, I will start, please send me few questions you faced in interviews
Super
Thank you
Can we write join query in using clause ?can we merge more than 2 tables.like joining of two table will update in target table.how to write?
Yes, you can, use the subquery instead of source table, however the target table should be only one table
How can we achieve SCD 1, 2 using plsql ?
Hi Sir,
I'm having one issue with merge statement, i wrote a merge state ment like below
Merge into trgt_table t1
Using src_table t2
On (t1.id=t2.id)
When matched then
Update set t1.name=t2.name;
But in my scenario there are multiple duplicate values are there in t1.id and t2.id columns because those are the referenced columns from another table.
When i execute this script I'm getting error
"Ora-30926 unable to get a stable set of rows in the source table"
Can you please help me out on this query
hi Sir facing Error "ORA-30926: unable to get a stable set of rows in the source tables" while merging the data of 2 tables having same structure...
Sir i have question
Ipl table having team name and player name
Mumbai rohit
Mumbai pollard
Mumbai boult
Delhi dhawan
Delhi rabada
Result should be
Mumbai delhi
Rohit dhawan
Pollard rabada
Boult null
Note : not using pivot function
Answer here itself thanks
if update record only have the resigned flag= Y means ?
Expectation is , Those records that marked as Y , should be removed from target table
@@SivaAcademy Thanks
❤
don't view only keep like and subscribe
Hi Siva Garu,
How to get Second Highest Average salary , Department wise ?
Deptno Avg(Sal)
10 1566
20 2175 ---> I need to display this department(Second highest average salary )
30 2916
Can you please share sql query for above question ?
Sure bro, will cover in upcoming video please stay tuned
@@SivaAcademy Can you share the video link
I am yet to post, will try to post in couple of weeks, please stay tuned