oracle plsql records and collections - rowtype

[@sarangdeshpande3093]

You are doing a fabulous job. You have ability to explain complicated topics in simplest way possible. Kudos 👍

[@SivaAcademy]

My pleasure, thank you 💐

[@vaibhavdalvi8570]

Sirji yr doing a fabulous wrk & You have ability to explain complicated topics in simplest way to understand every one.

[@SivaAcademy]

Thank you bro

[@shrihara]

@10:00 What's the point in declaring cursor for fetching a single row? Any achievement in performance?

[@jrdesaria]

Great explanation. Very helpful to refresh concept

[@SivaAcademy]

Thank you

[@pullareddym7288]

Hi @siva Academy - Just wonder that in update statement you used that set row = . are you trying to update entire row at a time? do you have a column called row in emp table?

[@SivaAcademy]

Yes, you can update entire row using row keyword

[@someshdhurve8850]

why exception is raise when we use select statement without where clause ? solution for that

[@kunuturuaravindareddy5580]

a lots of thanks for very basic detail explanantion.

[@SivaAcademy]

Welcome bro

[@dheemathimadhu847]

Very good explanation.Thank you so much.

[@SivaAcademy]

My pleasure, thank you

[@tejupansare4947]

Very good explanation

[@SivaAcademy]

Thank you

[@kumar-bi1to]

Excellent 👌 Thank you

[@SivaAcademy]

Welcome bro

[@WorldEye88]

Great explanation. Thank you.

[@SivaAcademy]

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

[@muhammadyasir8880]

Excellent Sir

[@SivaAcademy]

Thank you bro

[@gopigayathri7621]

Can you make videos on different types of cursors and the usage..

[@SivaAcademy]

@Gopi Gayathri, Sure, Please stay tuned for videos on Cursors,types and its usage.

[@shaikzakir5699]

Great explanation

[@SivaAcademy]

Thank you

[@gobirajendiran263]

Excellent sir🙏...

[@SivaAcademy]

@GOBI RAJENDIRAN, 🙏 Thank you bro!!!

[@prudhvireddy5260]

can you make video on pipelined function and how to debug the plsql code.

[@SivaAcademy]

@Prudhvi, sure, Please stay tuned.

[@poshpoise2526]

what is 1=2??why have u written that?? please explain

[@shivaprasad4292]

The reason you put the WHERE 1=2 clause in that SELECT INTO query is to create a field-copy of the existing table with no data. Table2 would be an exact duplicate of Table1

[@gsraj511]

Thanks Siva

[@SivaAcademy]

welcome bro

[@sudheerkumarreddy6447]

Can you share the notes of plsql as pdf format , I will pay for that also

[@prasanthinarasani6499]

Little bit fast sir...