oracle plsql records and collections MULTISET Operators

Подписаться 47 тыс.

Просмотров 18 тыс.

50% 1

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.
/ sivaacademy
---------------------------------------------------------------------------------------------------------------------------
Home page: sivakacademy.blogspot.com/
List of all oracle SQL/PLSQL Interview questions sivakacademy.blogspot.com/p/s...
List of all PLSQL Scenario based Interview Questions sivakacademy.blogspot.com/p/p...
List of all Subscriber questions and answers sivakacademy.blogspot.com/p/a...
---------------------------------------------------------------------------------------------------------------------------
Oracle Interview questions playlist • oracle interview quest...
Oracle 18C New features playlist • Oracle 18C New Feature
Oracle 12C New features playlist • Oracle 12C New Feature...
Oracle PLSQL records and collections playlist • oracle plsql records a...
---------------------------------------------------------------------------------------------------------------------------
My video courses at UDEMY www.udemy.com/user/2c29d781-3...
---------------------------------------------------------------------------------------------------------------------------
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
For any questions, please drop me a mail at siva.k.academy@gmail.com
---------------------------------------------------------------------------------------------------------------------------

Наука

Опубликовано:

29 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 70

@Arunkumar-yn3bw Месяц назад

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

@SivaAcademy 13 дней назад

Thank you very much

@krishnaraoutube 3 года назад

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

@SivaAcademy 3 года назад

Many thanks!

@sapnakansal6589 2 года назад

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

@SivaAcademy 2 года назад

Thank you

@subhashisoracle3944 4 года назад

Always Outstanding bro 🙏🙏🙏❤️❤️❤️

@SivaAcademy 4 года назад

Welcome bro 🙏💐💙

@gsraj511 2 года назад

Thanks Siva for your effort and clear explanation..

@SivaAcademy 2 года назад

You are welcome

@joseronald111 4 года назад

As always nice video and crystal clear explanation sir👍

@SivaAcademy 4 года назад

Welcome 🙏

@sooperyt5681 3 года назад

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

@SanjeevVerma32688 Год назад

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.

@ranajparida3902 4 года назад

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

@SivaAcademy 4 года назад

Sure bro, I will add to upcoming videos, please stay tuned

@arungurav6680 3 года назад

Excellent Job !! Fan of you Bro :-)

@SivaAcademy 3 года назад

Thank you 💐🙏

@junkingjunking8477 4 года назад

Superb explanation, sir.

@SivaAcademy 4 года назад

Thanks and welcome

@rakeshpanigrahi577 2 года назад

Excellent Siva, thanks a lot :)

@SivaAcademy 2 года назад

Welcome bro

@kunuturuaravindareddy5580 2 года назад

done with series thanks for your explanation.

@SivaAcademy 2 года назад

You're welcome!

@prateeksarangi9187 2 года назад

Wow !

@gsraj511 2 года назад

Thanks for the collections Playlist...

@SivaAcademy 2 года назад

Thank you bro

@rohanyadav1839 4 года назад

Thankss... Sir 👍

@SivaAcademy 4 года назад

Welcome 🙏

@yashtrologer 4 года назад

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

@vaibhavdalvi8570 2 года назад

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

@SivaAcademy 2 года назад

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

@harilearning9507 4 года назад

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

@MyFraggi 3 года назад

Awesomee

@SivaAcademy 3 года назад

Thank you

@masalhemant4255 3 года назад

very useful....

@SivaAcademy 3 года назад

Thank you

@harit5022 3 года назад

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

@shashank2004 4 года назад

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

@SivaAcademy 4 года назад

I was planning to start SQL tuning series, however it getting delayed, Will try my level best to start as soon as possible, and cover this question as part of that.

@MrRahulmaitra 6 месяцев назад

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

@debadattabeura6403 3 года назад

Nice explanation sir

@SivaAcademy 3 года назад

Thank you

@akhilps5332 3 года назад

In the final example: Multiset Except the out put is 2 3 4 5 8 8, but after applying distinct the output is 3 4 5 8. What happened to the 2. Could you please explain. I am all clear with your collection topics thanks to your deep knowledge.

@TheLeofromBoston Год назад

I hope that's just typo

@nimmylizthomas 2 года назад

great video! Pls do one on Oracle HINTS

@SivaAcademy 2 года назад

Thank you, please stay tuned

@nareshkatta9740 4 года назад

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?

@rohanyadav1839 4 года назад

Remove duplicate records through rowid over partition using then insert this records

@priyanshupathak5606 3 года назад

Hi Siva Sir great videos you are my next superhero for PL/SQL :) One question I was asked in interview few days back... Something like this Table A col1 col2 col3 a 1 2 b 4 5 c 7 8 output should be a b c 1 4 7 2 5 8 Write a query for this ? I have not figured out the solution for this yet , can you please post the solution for this. It will remove my doubts while facing the next interview. Thank you so much for making such 3C'S video's (Clear , Concise & Conceptual).

@SivaAcademy 3 года назад

Thank you for your comments bro, Next video is on this scenario based question only, please stay tuned

@dineshchandrapatnala1976 13 дней назад

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?

@SivaAcademy 13 дней назад

Yes bro you are right

@shaikrasheed2861 4 года назад

Sir,How to debug plsql code while developement?please give some tips ??

@SivaAcademy 4 года назад

sure, please stay tuned, i will add soon

@SriLife2 4 года назад

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

@SivaAcademy 4 года назад

Sure, please stay tuned I will add to upcoming videos

@satvinderbhangu361 4 года назад

Could you share any video how to use pragma autonomous.and why we use inside plsql

@SivaAcademy 4 года назад

Sure please stay tuned, I will add to upcoming videos

@satvinderbhangu361 4 года назад

Siva Academy thanks

@dastagiribala8717 4 года назад

How collections perform if we try to collect 100k+ numbers??

@SivaAcademy 4 года назад

definitely it will have impact, however, collecting such huge elements in collection is not recommended, instead you can think of some other design to implement.

@letsgooutdude5729 2 года назад

Hi bro , please create video on object type . How it is used in collection i.e in nested table in place of varchar we give object type..dml operations in that ...thanks ...if already there plz give the link

@SivaAcademy 2 года назад

Sure bro, will add to upcoming list, please stay tuned

@rampandraju1812 4 года назад

I have a question brother.I need to run a single procedure 20 times with different parameters in pl/sql As of Now I'm executing the same procedure by opening 20 new windows..Is there a way in pl/sql to execute all the 20 procedures at a time without opening 20 windows...and also need to monitor them

@SivaAcademy 4 года назад

Hi Ram, you can do using dbms_scheduler, also other methods also there, i will try to post a video on this topic soon, so that it helps everyone, please stay tuned

@rampandraju1812 4 года назад

@@SivaAcademy Thank you for your reply.... I already tried dbms_scheduler and it is working looking forward for some more methods and your as usual beautiful way of explanation

@rampandraju1812 4 года назад

@@SivaAcademy I started using dbms_scheduler but there is one problem for me with this i.e if any procedure got strucked in between while executing I'm not able to kill the session of dbms_scheduler.Can u explain this with some other methods please??

@SivaAcademy 4 года назад

You can use any programming language you know and call the SQL programmatically from some simple utility, i am preparing two different methods, one using dbms_shedule, and another using third party programming language, i will post the video soon, please stay tuned.

@deepakranjanmishra3 3 года назад

Running jobs can be stopped using the dbms_scheduler.stop_jobprocedure. begin dbms_scheduler.stop_job (job_name => 'your_job_name'); end; / So Siva sir just want to know can we use this package to kill running session.