oracle plsql records and collections type

oracle plsql records and collections - type

[abbeydudeuk]

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

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

[dissasekeram]

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

[vaibhavdalvi]

one of the interview question, great explanation thank you sirji

[jahongir]

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-ngzp]

Thanks for your efforts... Great explaination

[vijaysimhadri]

super explanation Siva. I really loved it.

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

[vaniganapathi]

Thank you so much for clear explanation sir

[pullareddym]

much appreciated for given commanding explanation

[deepakjagdale]

Thanks for Video sir.. Nice explaination..

[WorldEye]

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

[jiyasworld]

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

[parthasukla]

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.

[SAK-yj]

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.

[minicat]

From which version did record type support constructor?

[abhijitmandal]

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

[enockoloo]

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

[rajuraju-ggvf]

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

[karthikeyans]

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