oracle set operator union unionall intersect minus

[@NicolaeCristian175]

One of the best videos in KZbin. Thank you for sharing your knowledge

[@SivaAcademy]

@Nicolae, Thanks for your comment 🙏

[@ushathoughts7182]

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

[@SivaAcademy]

My pleasure, thank you so much for your support

[@yvsprakash]

excellent i cleared my doubt in set operators with this video

[@svvideo6792]

Excellent sir.one of the best explanation I have ever seen in KZbin...thank u

[@SivaAcademy]

Welcome bro 💐

[@tusharsonwane8468]

Thank you so much sir... explain very nicely as usual...now everything is clear about set operator's...🙏

[@SivaAcademy]

My pleasure bro, thank you 🙏

[@PriyankaKumari-ul7bv]

hi siva you are having good knowledge

[@SivaAcademy]

@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

[@PABERCRO]

Awesome - this clarified it a lot - thanks for your Video - cheers from Australia

[@SivaAcademy]

Thank you,

[@avulavenkatesh6921]

Never before ever after., Awesome explanation sir. Thank you so much sir. please can you make video on pipelined function sir.

[@SivaAcademy]

Welcome, sure please stay tuned

[@helpingustayfit]

Excellent video , concept clear 100%

[@SivaAcademy]

Thank you 🙏💐👍

[@vijaya1279]

Thanks Shiva for sharing the knowledge

[@SivaAcademy]

Thank you

[@gotchihaeyo1825]

I like the way you explain!! Thank you!

[@SivaAcademy]

Thank you

[@aravindrajendran581]

Your all videos are really good..please post related with collections

[@SivaAcademy]

Thanks Aravind, Sure, I will be posting collection related videos soon.

[@SivaAcademy]

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

[@rsivananth72]

Excellent explanation! Thank you.

[@SivaAcademy]

Thank you

[@syedshashmi541]

Best video in youtube👍

[@SivaAcademy]

Welcome

[@amarnathkota2551]

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?

[@ravivarma5094]

Good explaination great job😊

[@SivaAcademy]

Thank you

[@roctimjgogoi4006]

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

[@SivaAcademy]

Thank you, please stay tuned, will cover in upcoming videos

[@sivakrishna5639]

very Good explanation ...

[@SivaAcademy]

Welcome bro

[@munaforu]

what if to match the no. of columns, instead of one column name null will be placed ?

[@dissasekeram5217]

Excellent explanations !

[@SivaAcademy]

Thank you

[@anilk3233]

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?

[@SivaAcademy]

Welcome, Thanks for the sub!

[@ShobhaRani-uk2lg]

Could you please explain left outer join instead of minus query to compare two tables data

[@ShaluChaudhary]

What is merge,hash join,append difference?

[@mangoking4310]

Nice explanation ❤️

[@TheKetan4500]

your are best🎉

[@SivaAcademy]

My pleasure bro, thank you

[@vickypatekar9532]

Shiva Sir You are Awesome! Please Make Vedios on Execute Immediate

[@SivaAcademy]

@Vicky, sure, Please stay tuned.

[@sucharurani6834]

Which one is the best for tuning prospect between join and set operator ?And why ?

[@SivaAcademy]

Will post a seperate video on this topic, please stay tuned

[@sujaa1000]

Thank you Siva Regards, Sujaa

[@SivaAcademy]

Welcome 🙏

[@AbhiCirrius]

No, the SQL UNION operator does not sort data by default. used order by to sort the data

[@Divine_Power-bo6fz]

Is order of columns is also need to be same in both select statement....??

[@SivaAcademy]

Order not necessarily to be same, but data type should match across the queries

[@anujrana15893]

When u say sorted by default. Which column will be used to sort the result set?

[@SivaAcademy]

default ordering means, it sorts based on first, within first based on second column and so on

[@narutminto1234]

Good explanation 👏

[@SivaAcademy]

Thank you

[@CODEMASTER_TUTORIALS]

Great Explaination :)

[@SivaAcademy]

Thank you 💐

[@divyabaireddy6271]

Please post a video comparing set operators and joins

[@SivaAcademy]

@Divya, Sure, please stay tuned.

[@saptarshikonar3149]

Good one...

[@SivaAcademy]

@Saptarshi, Thanks for your comment :-). Regards, Siva

[@RS-hu9js]

Please do a video on merge statement

[@SivaAcademy]

Sure, please stay tuned

[@HolidayThoughts]

Please post user vs schema explanation

[@SivaAcademy]

Yes, please stay tuned

[@Anurag_Sharma2708]

Except and Minus Operators are same??????????

[@SivaAcademy]

Yes, both are same, however EXCEPT keyword is not available till 19C, available from 20 only

[@PriyankaKumari-ul7bv]

plz post vedio on cte (common table expression)

[@SivaAcademy]

@Priyanka, Sure, will post a video on cte, since there are few pending items in progress, will surely post once done. Thanks,Siva

[@chitrasrinivas7089]

Very useful br🙏

[@SivaAcademy]

Welcome 🙏💐

[@sai219cr]

What is the difference between union and intersect?

[@SivaAcademy]

@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

[@rajt5218]

Very nice anna

[@SivaAcademy]

Thank you

[@rajt5218]

HELPFUL Sir

[@SivaAcademy]

Thank you bro

[@albertogalindo5465]

Where are your accent from?

[@SivaAcademy]

India

[@amoghasoda]

Awesome!

[@SivaAcademy]

It's my pleasure,Thank you so much :-)

[@ShobhaRani-uk2lg]

Hi sir

[@di7787]

Very well explained, thank you !

[@SivaAcademy]

Welcome