2 PLSQL Performance Tuning Bulk Collect Part 1

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

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

50% 1

2 PLSQL Performance Tuning Bulk Collect Part 1
Oracle PLSQL records and collections at • oracle plsql records a...
-----------------------------------------------------------------------------------
Oracle Interview questions and Answers at • oracle interview quest...
Oracle 18C New features at • Oracle 18C New Feature
Oracle 12C New features at • Oracle 12C New Feature...

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

30 сен 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

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

Could you please explain hints and how parallel hint work?

@jrdesaria 2 месяца назад

Siva wonderful teaching method!!!

@SivaAcademy 2 месяца назад

Thank you 🙏

@Mohanraj-li9ff 5 лет назад

Thanks for describing the context switching and bulk binding in short. Have doubt in bulk collection... If there is no records available while using "bulk collect into" clause, will it raise the exception.

@SivaAcademy 5 лет назад

@Mohan, thanks for your comment. No data found exception won't get raised while doing as part of bulk collect clause.

@aabha21aug 5 лет назад

Super as always!!👍👍 Looking forward to videos on topics like subprograms, sequence, analytical functions.. Keep up the good work! 🙏

@SivaAcademy 5 лет назад

Thank you...🙏🙏....Sure, please stay tuned.

@aravindrajendran581 5 лет назад

Nice one..as usual Good effort...

@SivaAcademy 5 лет назад

@Aravind, 🙏 thanks bro

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

Can we give tablename % row type while defining nestedtable type It should be of same data type like scalar or it can be composite also?

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

It can be composite also

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

Difference between bulk collect and bulk binding

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

Sure, Please stay tuned, will be posting soon

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

Instead of loading the data from the rowtype into collection why dont you load the data directly to collection ? Is there any specific reason for that. Because here the processing for oracle enginee is increased by storing in rowtype scalar varialbe and then to collections !

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

Nice explanation. Could you please tell me about the limit clause in bulk collect and how to decide the limit number?

@munadakua4210 5 лет назад

Please make one video about no copy clause in real time scenario.

@SivaAcademy 5 лет назад

Sure, please stay tuned

@vaniganapathi830 3 месяца назад

Is it possible to load selected columns alone into a nested table through bulk collect

@enjoyfriends873 8 месяцев назад

Hi Siva Please explain - synonym with examples

@shrikantjoshi3174 Год назад

Very nicely explained. Thank you, sir.

@SivaAcademy Год назад

Welcome 🙏💐

@saiswaroop3570 Год назад

how to display and access records by storing in collections type

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

If employee table has 1 million records,will it make any difference in the below 2 queries:1.select * bulk colllect into from employee...2. select * bulk collect into from employee limit 1million;

@kumar-bi1to 2 года назад

Thank you very much. Explained very clearly

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

You are welcome!

@shripadkulathe5002 5 лет назад

Please upload a videos on partition .

@SivaAcademy 5 лет назад

Sure, Please stay tuned.

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

Thank you, Siva, for your great content!

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

My pleasure, thank you

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

Could you please help one video on additional features added to oracle higher than 11g version

@ramnagireddy4261 5 лет назад

What an explanation brother... Awesome 👌👌 Can you please do an video :diff b/w ForAll and Bulk collection(asked in my one of the PLSQL interview)

@SivaAcademy 5 лет назад

@Ram, sure, will post in the same video series, please stay tuned.

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

Hi Sir, in PLSQL collections videos all of with particular column to select and load the data to collection, so thought collection will store more rows with same datatype. But in this video we are storing different datatypes. Can you please explain?

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

Collection of rowtype variable can store multiple rows of same rowtype value, is it clear??

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

In addition to context switching reduction, undo,redo log file entry also can be reduced by bulk binding. Is that right sir?

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

we are awaiting for your bind variable videos. when shall we expect that videos in your playlist?

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

As soon as possible bro, please stay tuned

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

por favor podrias habilitar subtitulos para este capitulo, el video 2,3,4 y 5 no lo tienen. gracias.

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

Gracias por tus comentarios, incluiré subtítulos para los próximos videos.

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

Nice explanation but I could see only 2 videos on performance tuning... can you please point me if any other videos

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

i am working other videos, please stay tuned

@AliBaba-mx8of Год назад

Sir,please make video on hints

@SivaAcademy Год назад

sure, please stay tuned

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

Nice information.. thanks

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

Welcome

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

Awesome explanation.. can u please explain detail about bulk collect and forall...

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

Sure, please stay tuned

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

Can upload function and stored procedure

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

Great 👌👌👌👌. Pls make a video on collection exceptions.

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

Sure Ram, please stay tuned for more videos on collections

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

Hi Sir... One interviewer asked to write a code for to get all details from one table using bulk collect and insert into another table which will be insert 20,20 records... please do video for this...

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

Sure please stay tuned, I will post soon

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

U can use limit clause in bulk collection you will get 20,20 records

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

Thank you ..!! Very good video.. pls upload part2 video

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

Welcome 🙏, please stay tuned for next part

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

Supper

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

No words to say

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

Thank you

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

Good one

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

Thanks

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

Hi Shiva, Your Video is Super informative as always. Kindly clarify a point, not related to Bulk Binding, but Binding Variable in general- Are all variables declared in a procedure treated as 'Bind Variable' ? If no, can you specify where all in a procedure should we explicitly define a variable as a bind variable. Thanks