oracle plsql records and collections type

[@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?

[@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

[@abbeydudeuk]

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

[@SivaAcademy]

Thank you 💐🙏

[@zakariyamuhammad2148]

very clear explanation

[@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

[@jiyasworld2021]

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

[@SivaAcademy]

Thank you

[@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

[@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

[@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.

[@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

[@vijaysimhadri9213]

super explanation Siva. I really loved it.

[@SivaAcademy]

Thank you so much 🙂

[@vaibhavdalvi8570]

one of the interview question, great explanation thank you sirji

[@SivaAcademy]

Welcome bro

[@SanjayKumar-ng7zp]

Thanks for your efforts... Great explaination

[@SivaAcademy]

Welcome 💐 🙏

[@kumar-bi1to]

Explained very detailed. Thank you

[@SivaAcademy]

My pleasure bro, thank you

[@pullareddym7288]

much appreciated for given commanding explanation

[@SivaAcademy]

Thank you

[@Ervaradsawant]

Very well Explained..

[@SivaAcademy]

Thank you

[@abhijitmandal9989]

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

[@Ins_8800]

Very clear and helpful, best 💯👍

[@SivaAcademy]

Thank you 🙏💐

[@vaniganapathi830]

Thank you so much for clear explanation sir

[@SivaAcademy]

Welcome

[@enockoloo3814]

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

[@karthikeyans3278]

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

[@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.

[@diraneserges6076]

Thank very much

[@SivaAcademy]

Welcome

[@raju26067]

Thanks for indetail explanation....

[@SivaAcademy]

Thanks a lot for your comment Raju :-)

[@gsraj511]

Thanks Siva...

[@SivaAcademy]

welcome bro

[@deepakjagdale6215]

Thanks for Video sir.. Nice explaination..

[@SivaAcademy]

Thank you 🙏🙏

[@shanthishda2822]

Superrr sir thank u...

[@SivaAcademy]

Welcome bro

[@sujaa1000]

Thank you Siva.
Sujaa

[@SivaAcademy]

Welcome

[@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

[@narendraganji2319]

Thank you sir....

[@SivaAcademy]

🙏🙏

[@gunjanbhatt4543]

Hi Sir,
Please make video on utl_file.
Thanks

[@SivaAcademy]

Sure, please stay tuned bro

[@gunjanbhatt4543]

@@SivaAcademy will be waiting 😊