You are the best resource for who is looking for oracle sql /plsql.Thank you so much. We want more videos regarding this skill and will support what can we do for that
@Priyanka, Everything is available in oracle documentation, I just tried my level best to present in a way it can be easily understood by every one, That's it :-), And thanks a lot for your comments :-) Regards, Siva
The explanation is great. I'm following this channel for a long time now and the way the sql concepts are delivered is just awesome. But I've one request, could you address one more question as for this video. What's the difference between where exist and where not exist to intersect and minus set operations??
Aravind, I started posted collection related videos, let me know if you are looking for any specific concept in collection, i will add as part of upcoming videos. Thanks, Siva
Man! You are awesome. Thank you so much for your detailed explanation. Yes! you guessed it rite, I have now subscribed to your channel :). Could you please do videos on OVER and PARTITION BY clauses?
@Sai Ram, UNION --> combine the data of two result set and display in sorted order after removing duplicate rows INTERSECT --> Display the common rows between result sets after removing the duplicates, and display in sorted order
One of the best videos in UA-cam. Thank you for sharing your knowledge
@Nicolae, Thanks for your comment 🙏
You are the best resource for who is looking for oracle sql /plsql.Thank you so much.
We want more videos regarding this skill and will support what can we do for that
My pleasure, thank you so much for your support
excellent i cleared my doubt in set operators with this video
Never before ever after., Awesome explanation sir.
Thank you so much sir.
please can you make video on pipelined function sir.
Welcome, sure please stay tuned
hi siva
you are having good knowledge
@Priyanka, Everything is available in oracle documentation, I just tried my level best to present in a way it can be easily understood by every one, That's it :-), And thanks a lot for your comments :-)
Regards, Siva
Excellent sir.one of the best explanation I have ever seen in UA-cam...thank u
Welcome bro 💐
Awesome - this clarified it a lot - thanks for your Video - cheers from Australia
Thank you,
Thank you so much sir... explain very nicely as usual...now everything is clear about set operator's...🙏
My pleasure bro, thank you 🙏
The explanation is great. I'm following this channel for a long time now and the way the sql concepts are delivered is just awesome.
But I've one request, could you address one more question as for this video. What's the difference between where exist and where not exist to intersect and minus set operations??
Thank you, please stay tuned, will cover in upcoming videos
Excellent video , concept clear 100%
Thank you 🙏💐👍
Thanks Shiva for sharing the knowledge
Thank you
Very well explained, thank you !
Welcome
Your all videos are really good..please post related with collections
Thanks Aravind, Sure, I will be posting collection related videos soon.
Aravind, I started posted collection related videos, let me know if you are looking for any specific concept in collection, i will add as part of upcoming videos. Thanks, Siva
I like the way you explain!! Thank you!
Thank you
Good explaination great job😊
Thank you
Man! You are awesome. Thank you so much for your detailed explanation. Yes! you guessed it rite, I have now subscribed to your channel :).
Could you please do videos on OVER and PARTITION BY clauses?
Welcome, Thanks for the sub!
Best video in youtube👍
Welcome
very Good explanation ...
Welcome bro
Good one...
@Saptarshi, Thanks for your comment :-). Regards, Siva
Excellent explanations !
Thank you
your are best🎉
My pleasure bro, thank you
Nice explanation ❤️
Shiva Sir You are Awesome! Please Make Vedios on Execute Immediate
@Vicky, sure, Please stay tuned.
No, the SQL UNION operator does not sort data by default. used order by to sort the data
Good explanation 👏
Thank you
Great Explaination :)
Thank you 💐
Thank you Siva
Regards,
Sujaa
Welcome 🙏
Do we still get duplicates of we use distinct key word in the select and use union all?
Also, how does it impact the performance?
Very useful br🙏
Welcome 🙏💐
HELPFUL Sir
Thank you bro
Please post a video comparing set operators and joins
@Divya, Sure, please stay tuned.
Awesome!
It's my pleasure,Thank you so much :-)
What is merge,hash join,append difference?
Could you please explain left outer join instead of minus query to compare two tables data
Very nice anna
Thank you
Which one is the best for tuning prospect between join and set operator ?And why ?
Will post a seperate video on this topic, please stay tuned
what if to match the no. of columns, instead of one column name null will be placed ?
When u say sorted by default. Which column will be used to sort the result set?
default ordering means, it sorts based on first, within first based on second column and so on
Is order of columns is also need to be same in both select statement....??
Order not necessarily to be same, but data type should match across the queries
Please do a video on merge statement
Sure, please stay tuned
Please post user vs schema explanation
Yes, please stay tuned
plz post vedio on cte (common table expression)
@Priyanka, Sure, will post a video on cte, since there are few pending items in progress, will surely post once done. Thanks,Siva
What is the difference between union and intersect?
@Sai Ram,
UNION --> combine the data of two result set and display in sorted order after removing duplicate rows
INTERSECT --> Display the common rows between result sets after removing the duplicates, and display in sorted order
Except and Minus Operators are same??????????
Yes, both are same, however EXCEPT keyword is not available till 19C, available from 20 only
Hi sir
Where are your accent from?
India
Excellent explanation! Thank you.
Thank you