oracle plsql records and collections introduction to oracle collections

[@C.K.Arun.]

My Confident level also Incremented daily, Starting from Count = 1; Now ++Thanks to Siva Sir and @SivaAcademy

[@simarpreetsingh7517]

Thanks for the videos. Explained very well. Best tutorial we can find for plsql.

[@sanketjain6576]

Thank you so much. I think you are allowing us to learn with the most easier/advanced way. This is the best platform I have ever seen.

[@SivaAcademy]

My pleasure bro, thank you 💐💐

[@C.K.Arun.]

This is the best platform I have ever seen. i also AGREE.

[@shanugarvit]

Excellent detailed tutorial!! voice and video quality as well as superb.

[@SivaAcademy]

Thank you

[@durgakumar5669]

Nice sir you did explain very simple and effective manner really you are best in explanation I have ever seen this. Thank you sir.

[@SivaAcademy]

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

[@sivachandrareddy9504]

up to day i am very poor in Collections and ref cursor. but today on words i can say confidently i know the collection and remains. thanks a lot for your efforts and nice explanations sir. with out watching your videos my day will not complete

[@SivaAcademy]

It's my pleasure, thanks for your comments 🙏🙏🙏

[@C.K.Arun.]

My Confident level also Incremented daily from Count = 1; Now ++Thanks to Siva and @@SivaAcademy

[@manjunathreddy3484]

Good explanation! Most of the interviews they ask this question... 1) cost based optimizer 2) Rule based optimizer 3) Pipeline function 4)Table function

[@SivaAcademy]

Sure, please stay tuned, I will add in upcoming videos

[@sjshirolkar]

Your explanation on basics of datatypes is excellent!

[@SivaAcademy]

My pleasure, thank you 💐

[@juno7893]

This is exqctly what I needed. Thank you 🙏

[@SivaAcademy]

My pleasure 💐🙏

[@aravindrajendran581]

Thank you very much sir.... As usual this one also very good... keep rocking...

[@SivaAcademy]

Thanks Aravind, if you are looking for any specific collection related concept, let me know, i will add as part of upcoming videos. Thanks Siva.

[@aravindrajendran581]

@@SivaAcademyOK sir .. Thanks ... Will comment you if any topic needed ..thanks for your passion..

[@sasikumar85005]

@Siva Academy can you please post the video about o2c flow and interview questions in Oracle apps

[@Seema_Cute]

nice video, but where is the video for Collections and bulk binding

[@satya3233]

Thank you!! for giving us a valuable sessions!!

[@aadarshchoudhary-y8v]

very thankful sir. your videos are very helpful.

[@SivaAcademy]

Thank you

[@prashanthadapad2466]

Thank you soo much for all the videos you posted,is very descriptive and helpful.

[@SivaAcademy]

Welcome 🙏

[@shashank2004]

Awsome video sir.., pls make a video on nested loop join, hash join, semi merge join... How its work.. And also make a video on explain plan how its internally work... And reverse key index

[@SivaAcademy]

Thanks Shashank, Sure will upload videos on joins, Regarding reverse key index, stay tuned, next upcoming videos on interview questions are b-tree index, bitmap index and reverse key index. Thanks, Siva

[@C.K.Arun.]

Hi Siva Sir, Can you please do Video on nested loop join, hash join, semi merge join.@@SivaAcademy

[@gopalakrishnagattupalli7447]

Thank you so much, could you also provide the regular expression related please.. my requirement is to " search the tags in one table and display the URLs in our portal " simulating the search in our internal portal

[@madhankumar001]

Hi Siva, As you confirmed in this video that you will be explaining bulk binding. But it is not there any of this 8 videos. Please let me know if you have it in any other playlist.

[@SivaAcademy]

@Abinash, Sure bro....next video series is on performance tuning only...will be starting from next week....will be covering bulk collect and concepts as part of that....please stay tuned.

[@subhalakshmi8833]

Nice explanation for each video keep on rocking sir Are you talking any class Let me know it sir

[@SivaAcademy]

Thank you 💐

[@Ganeshay-09]

i have one doubt in the collection u said we can store in variable .. varray (7) -- and varchar2 (30) in 7 varray is given varchar2 but if we will take number data type then we can store in number datatype its means can take number datatype in varray (7)..

[@santoshdash-g4n]

Sir, Can you create a video for explain plan. How to read explain plan and interview related questions

[@navaneethakj4100]

Hi @sivaAcademy , can you please share the codes used in the videos

[@ManojKumar-il8vt]

superb vedio siva sir .....always rocks

[@SivaAcademy]

Thank you so much :-)

[@rage1694]

Can we use collection as data type for user defined record

[@rsreddy1737]

Very helpful information sir thank you.. Could you pl provide a link for whole Plsql document.

[@C.K.Arun.]

@Siva Academy Hi Siva Sir, please make series for SQL performance tuning. If EXISTS then "SHARE LINK".

[@SANK8MADEIT]

Best Video till Date 🙏😊

[@SivaAcademy]

My pleasure :-) thank you

[@kunuturuaravindareddy5580]

Hi Siva as per the documentation %type and %rowtype are classified as anchor data types and we have one abstract data type can you comment on this please.

[@ajinkyagaikwad2387]

Hi Bro, I found one issue on production for PLSQL table and this was a unexpected issue for me,, PLSQL tables were tested several time on lower instance stage and dev ,,,the issue is I am storing the email id's in PLSQL table on runtime ,,sometimes it gets values like 1 email id ,2 id's,3id's , 15 id's and once it got like maximum Id's then if next is 2 then also collection store this 2 values at start and next 13 values kept as it is and sent email to that remaining 13 as well with that 2 values instaed of sending 15 emails it should send only 2 and only send email to that 2 I'd,s,, Have you faced this type of issue in a past with collecteion ? If yes then how you handled it ? But before it handled why ARRAY behaviour abonormally in above scene ?,,, I am expeextinhg your suggestions/answer on this ? ,,, Thanks in advance ,,,,please reply me if you are having any documents or anything about this issue 😔😔😔😔

[@sudharsansanjay2388]

Was that resolved?? If yes could you explain please?

[@Ananda_vmp]

Could you post a video about about packages ,local and an global variables ? .

[@SivaAcademy]

Yes, please stay tuned

[@rajtirthadutta3938]

Thank you so much Sir . Really Helpful but I have a question Which is What is Bulk Binding?? Here At Last You Told us that Collection + Bulk binding helps to work in PL/SQL.

[@SivaAcademy]

Welcome, please look into this video kzbin.info/www/bejne/p3mXaIB5pLyihLc

[@bharathipandian45]

All credit goes to you siva if I get selected in interviews. Waiting for the results....your videos make me to learn everything everyday

[@SivaAcademy]

Its my pleasure :-)

[@vaibhavdalvi8570]

Awsome work sirji

[@SivaAcademy]

Thank you

[@gorakhnathupadhyaygarry]

How to difference between collection function and function ?

[@bogov6762]

Very good! Thank you sir!

[@SivaAcademy]

Thank you

[@manikandanpanneer1650]

Thanks Sir, We are in 2024. Does Oracle has big scope in job.

[@dheemathimadhu847]

Very good explanation. thankyou so much.

[@SivaAcademy]

Welcome 💐

[@siddeshbagali13]

Superb sir....Please make videos on Hadoop technology..!

[@SivaAcademy]

Yes bro, soon, i will be posting on Hadoop, please stay tuned

[@shibasahu6230]

Hi sir Thanks a lot for all your video, I know these thing but not able to explain in interview cause but now I feel like I can explain. Can you please help us by making a video on how to optimize a big query by seeing it's axplain plan cause every is missleading on this topic and nobody explain batter then you.

[@SivaAcademy]

My pleasure, thank you, sure please stay tuned

[@C.K.Arun.]

how to optimize a big query by seeing it's axplain plan cause every is missleading on this topic and nobody explain batter then you.@@SivaAcademy Please do one video for this Siva Sir.

[@jitendrapattnaik978]

Please share the performance tuning videos.

[@SivaAcademy]

@jitendra, very recently started the performance tuning series, will add more videos soon here. Here is the link plsql performance tuning: kzbin.info/aero/PLb1qVSx1k1VrPd8FT8WI6Btu754TZjqIs

[@venkateshk8854]

Sir>> COuld u please provide complete E2E trainning for Oracle sql and plsql, as am eagerly looking for it..tx

[@FaisalFaizz]

Great video👍👍

[@SivaAcademy]

Thank you 👍

[@poojapatil7970]

Thank you, sir. Very good explanation.

[@SivaAcademy]

You are welcome

[@ramchinthakayala2092]

pls tell me where the cursor data type fits in oracle data types? Can we pass collection as parameter to the procedure ?

[@SivaAcademy]

yes, we can pass collection as parameter, i will try to post this with example in collection video series, please stay tuned.

[@C.K.Arun.]

@@SivaAcademy passing collection as parameter, Please make a video for your beloved students siva sir. thank you

[@PGhai]

Hey Siva, I want to learn full Oracle but getting lost in multiple videos, do you have a playlist from start to end?

[@SivaAcademy]

Oracle basics, I am yet to cover, please stay tuned, will create a new playlist

[@PGhai]

@@SivaAcademy Thanks for reply, waiting for same

[@nileshkesari8497]

U didn't explained about bulk binding in this playlist. I think this playlist is incomplete.

[@SivaAcademy]

Covered in another playlist, kindly check

[@masalhemant4255]

very helpful...........

[@SivaAcademy]

Thank you

[@jagneethi]

compariosn of C languauge and PL/SQL was excellent

[@SivaAcademy]

Thank you 💐

[@abhisheknegi8053]

By using the %rowtype can we retrieve multiple records instead of single record at a time

[@SivaAcademy]

No, rowtype can hold only one row, you need collection to hold multiple row

[@abhisheknegi8053]

@@SivaAcademy thanks a lot

[@abhisheknegi8053]

@@SivaAcademy please make videos on oracle cloud

[@SivaAcademy]

Sure bro, please stay tuned

[@harinadhbabu309]

Awesome👏✊👍

[@SivaAcademy]

Thanks ✌️

[@priyanshupathak5606]

Great , can you please do a video on transposing table rows in columns. 1>Using pivot 2>Case

[@SivaAcademy]

Please look into this video kzbin.info/www/bejne/nqW9g4mYiNx4oNk

[@sagarjadhav299]

please make series for SQL performance tuning

[@SivaAcademy]

@Sagar, Sure, I will upload soon, Please stay tuned.

[@sagarjadhav299]

very good explanation sir

[@SivaAcademy]

@Sagar, Thanks for your comment.

[@raju26067]

What is the major difference between ASSOCIATIVE ARRAY and NESTED TABLE AND VARRAY? Please explain this question in experienced level

[@SivaAcademy]

Sure, i will cover this in upcoming video about collection.

[@shabharishthati905]

Thanku.sir.explained very.well

[@SivaAcademy]

Thank you

[@parikshelke3342]

Thanks sir very useful

[@SivaAcademy]

Welcome bro 💐

[@tripsee657]

Thank you Sir,

[@krishnareddy2885]

Tnq Very Much Sir...

[@SivaAcademy]

Welcome Krishna, I will cover most of the collection related concepts, if you are looking for any specific concept, let me know also, i will add as part of upcoming videos. Thanks Siva.

[@krishnamohan5898]

nice sir

[@SivaAcademy]

Thanks and welcome

[@shahulhameedbadhusha1270]

❤

[@KrishnaPaneri]

Thank you.

[@SivaAcademy]

Welcome 🙏