oracle plsql records and collections MULTISET Operators

oracle plsql records and collections MULTISET Operators
---------------------------------------------------------------------------------------------------------------------------

This channel is for learning Oracle SQL, PLSQL, DATABASE concepts, MYSQL, ETL, Mongo DB, Python,UNIX and related technologies.

---------------------------------------------------------------------------------------------------------------------------

---------------------------------------------------------------------------------------------------------------------------

---------------------------------------------------------------------------------------------------------------------------

---------------------------------------------------------------------------------------------------------------------------
About Myself:
----------------------
I am Siva, [LEARN | CODE | TRAIN | SHARE].
Being in IT industry for more than 10 years.
In my day to day job, I work with database technologies including Oracle, Java, Python, MongoDB, talend and UNIX.
I am passionate about "DATA", coding & training.
In my spare time, I teach database technologies , ETL etc.
I am very glad that you are reading my Profile, and I value your time as well as mine.
Looking forward to see you in my videos

---------------------------------------------------------------------------------------------------------------------------

[Arunkumar-ynbw]

Excellent play list for records and collections .. your explanation is just awesome.. thanks for doing the good work.

[sooperyt]

The multiset except distinct has removed 2 as well along with 8.. which means that it first take distinct elements from each collection and then applied minus!!!

[krishnaraoutube]

Good presentation with required examples. All Oracle videos are great.

[gsraj]

Thanks Siva for your effort and clear explanation..

[ranajparida]

Superb explanation. Really you should explain below concepts
1. DETERMINISTIC CLAUSE
2. RESTRICT_REFERENCE
3. PARALLEL_ENABLE
4. PIPELINED
5. RESULT_CACHE WITH RELAY

[gsraj]

Thanks for the collections Playlist...

[kunuturuaravindareddy]

done with series thanks for your explanation.

[sapnakansal]

Beautifully explained, thanks for all these content.Keep posted :)

[vaibhavdalvi]

awesome work Sirji, We are waiting for at least one project explanation if possible...thanks in advance

[shashank]

Awsome explanation bro .. Pls make a video on explain plan internally how it's working?

[SanjeevVerma]

Incase of except multiset. If we have multiple value in one set and single value in another set in that case also we will get the extra value from first set. But if we used distinct keyword then Oracle will compare the value on distinct set then only we will get the correct dataset.

[SriLife]

Good explanation Siva. I requested u to do a videos on pipeline function.

[yashtrologer]

Nice explanation Siva. As you said that sorting is not possible but is there any way to sort the order of output?

[joseronald]

As always nice video and crystal clear explanation sir👍

[MrRahulmaitra]

L3 you have not initialised or extended before using, so how it’s working?

[nimmylizthomas]

great video! Pls do one on Oracle HINTS

[dineshchandrapatnala]

Siva, thanks for your efforts.
One topic you did not cover as you said like we will not skip the collections without Bulk binding and bulk collect, right?

[harilearning]

Thanks Sir Clearly understood ur videos are helping me a lot one doubt sir i am getting the bulk data from select statement using bulk collect to nested table which is type of record but it is inside the for loop every time nested table is overriding.suppose if i iterate 5 times bulk collect nested table is overriding how to hold all the data could you please help on this Thanks in advance

[nareshkatta]

I have a table in that table 100 records available, some recors are duplicates in that 100 records.i need to inset again 50 records in that table now table will not allow duplicate recods.how to write plsql program for this?

[harit]

Hi sir this is Hari. can we perform multiset operators on associative arrays ?