oracle plsql records and collections type

[@zakariyamuhammad2148]

very clear explanation

[@BewithuNnk]

Hi Siva, it's really helpful whoever wants to learn plsql concepts at the stage of beginning. Plzz help for my queries? 1.Is it possible to share the bind variables across the plsql blocks and is it access in different sessions? 2.Does record type variable hold row type variable?

[@abbeydudeuk]

the best thing I like about your videos is the last slide showing all styles in 1 slide.

[@SivaAcademy]

Thank you 💐🙏

[@dissasekeram5217]

Hi Siva, Awesome! All your explanations with videos are excellent , very clear and easy to understand along with proper examples . 👍

[@SivaAcademy]

Thank you bro

[@vaibhavdalvi8570]

one of the interview question, great explanation thank you sirji

[@SivaAcademy]

Welcome bro

[@vijaysimhadri9213]

super explanation Siva. I really loved it.

[@SivaAcademy]

Thank you so much 🙂

[@jahongir2212]

Hi thanks for explaining, I’ve a problem: Have a record type like your emp_rec_type… so I do: Some loop i := count+1; emp_rec(i).empname := loop.value1 emp_rec(i).empsal := loop.value2 End loop; So how can i get a unique values in emp_rec I’m using this: if not emp_rec.exist(loop.value1) then …. end if; Here i get a boolshit

[@SanjayKumar-ng7zp]

Thanks for your efforts... Great explaination

[@SivaAcademy]

Welcome 💐 🙏

[@snehabhoyi]

Hey Siva, really loved the way you explain concepts. Simple and brilliant! Would like to see some videos on partitioning as well. Are there any which you have already recorded?

[@SivaAcademy]

Thank you, I am yet to post videos on partitions, please stay tuned

[@kumar-bi1to]

Explained very detailed. Thank you

[@SivaAcademy]

My pleasure bro, thank you

[@vaniganapathi830]

Thank you so much for clear explanation sir

[@SivaAcademy]

Welcome

[@Ervaradsawant]

Very well Explained..

[@SivaAcademy]

Thank you

[@Ins_8800]

Very clear and helpful, best 💯👍

[@SivaAcademy]

Thank you 🙏💐

[@pullareddym7288]

much appreciated for given commanding explanation

[@SivaAcademy]

Thank you

[@enockoloo3814]

the materials are great but some are redundant//repeated.

[@gsraj511]

Thanks Siva...

[@SivaAcademy]

welcome bro

[@diraneserges6076]

Thank very much

[@SivaAcademy]

Welcome

[@shanthishda2822]

Superrr sir thank u...

[@SivaAcademy]

Welcome bro

[@raju26067]

Thanks for indetail explanation....

[@SivaAcademy]

Thanks a lot for your comment Raju :-)

[@sujaa1000]

Thank you Siva. Sujaa

[@SivaAcademy]

Welcome

[@jiyasworld2021]

Hi Siva wonderful explaination just want to know how many field we can Store in record type ?

[@SivaAcademy]

Thank you

[@parthasukla2758]

Hi Siva, Thanks for making such type of videos. Could you let us know what is the difference between record type and object. Thanks in adv.

[@SivaAcademy]

Sure please stay tuned

[@deepakjagdale6215]

Thanks for Video sir.. Nice explaination..

[@SivaAcademy]

Thank you 🙏🙏

[@abhijitmandal9989]

Hi.. Anyone pls answer this question.. Why records can not be created at schema level?

[@WorldEye88]

Thank you Siva. Please help me with notion on Global Variable assignments. Do you have a video on his subject?

[@SivaAcademy]

No videos right now, i will add this to my upcoming list.

[@WorldEye88]

@@SivaAcademy Thank you. I'll wait.

[@SAK-y6j]

Thanks for sharing .Your video lectures are really awesome. I have a doubt in this lecture. As per my knowledge space or empty string is not Null in oracle . How Null error response is generated when empty string is assigned to the field ? Please clarify.

[@SivaAcademy]

Sure will post a video specifically for null VS empty string

[@minicat1983]

From which version did record type support constructor?

[@chandalurianand4048]

Hi @minicat1983, From 18c onwards, any PL/SQL value can be provided by a qualified expression, just like a constructor provides an abstract data type value.

[@rajuraju-gg7vf]

Hi sir,we can fetch multiple records by using record type.

[@SivaAcademy]

If you use other collection type like array, nested table then you will be able to save and get multiple values

[@karthikeyans3278]

Hi, I think we can create a record in schema level. Like CREATE TYPE objtyp ( c1 NUMBER, c2 VARCHAR2(10) );

[@narendraganji2319]

Thank you sir....

[@SivaAcademy]

🙏🙏

[@kodurupavan3712]

how to write a program to display all values in emp table by using %type.

[@SivaAcademy]

Please stay tuned, i post a video by next week on this topic

[@gurikarichinnavenkatesh8425]

Sir please give pdf material for all this questions it's my humble request sir

[@gunjanbhatt4543]

Hi Sir, Please make video on utl_file. Thanks

[@SivaAcademy]

Sure, please stay tuned bro

[@gunjanbhatt4543]

@@SivaAcademy will be waiting 😊