oracle plsql records and collections introduction to oracle collections
ฝัง
- เผยแพร่เมื่อ 22 ม.ค. 2025
- oracle plsql records and collections - Introduction to collections in oracle
oracle collections tutorial series - Video -1 , introduction to records and collections
Thanks for the videos. Explained very well. Best tutorial we can find for plsql.
My Confident level also Incremented daily, Starting from Count = 1; Now ++Thanks to Siva Sir and @SivaAcademy
Excellent detailed tutorial!! voice and video quality as well as superb.
Thank you
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.
My pleasure bro, thank you 💐💐
This is the best platform I have ever seen. i also AGREE.
Nice sir you did explain very simple and effective manner really you are best in explanation I have ever seen this.
Thank you sir.
It's my pleasure,Thank you so much :-)
Your explanation on basics of datatypes is excellent!
My pleasure, thank you 💐
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
It's my pleasure, thanks for your comments 🙏🙏🙏
My Confident level also Incremented daily from Count = 1; Now ++Thanks to Siva and @@SivaAcademy
Good explanation!
Most of the interviews they ask this question...
1) cost based optimizer
2) Rule based optimizer
3) Pipeline function
4)Table function
Sure, please stay tuned, I will add in upcoming videos
Thank you very much sir....
As usual this one also very good...
keep rocking...
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.
@@SivaAcademyOK sir .. Thanks ... Will comment you if any topic needed ..thanks for your passion..
@Siva Academy can you please post the video about o2c flow and interview questions in Oracle apps
This is exqctly what I needed. Thank you 🙏
My pleasure 💐🙏
Thank you!! for giving us a valuable sessions!!
Thank you soo much for all the videos you posted,is very descriptive and helpful.
Welcome 🙏
Best Video till Date 🙏😊
My pleasure :-) thank you
very thankful sir. your videos are very helpful.
Thank you
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
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
Hi Siva Sir, Can you please do Video on nested loop join, hash join, semi merge join.@@SivaAcademy
superb vedio siva sir .....always rocks
Thank you so much :-)
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.
@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.
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)..
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
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 😔😔😔😔
Was that resolved?? If yes could you explain please?
All credit goes to you siva if I get selected in interviews. Waiting for the results....your videos make me to learn everything everyday
Its my pleasure :-)
nice video, but where is the video for Collections and bulk binding
Very good explanation. thankyou so much.
Welcome 💐
Awsome work sirji
Thank you
Hi @sivaAcademy , can you please share the codes used in the videos
Nice explanation for each video keep on rocking sir
Are you talking any class
Let me know it sir
Thank you 💐
Can we use collection as data type for user defined record
Thank you, sir. Very good explanation.
You are welcome
Very good! Thank you sir!
Thank you
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.
@Siva Academy Hi Siva Sir, please make series for SQL performance tuning. If EXISTS then "SHARE LINK".
Sir, Can you create a video for explain plan. How to read explain plan and interview related questions
Could you post a video about about packages ,local and an global variables ? .
Yes, please stay tuned
pls tell me where the cursor data type fits in oracle data types? Can we pass collection as parameter to the procedure ?
yes, we can pass collection as parameter, i will try to post this with example in collection video series, please stay tuned.
@@SivaAcademy passing collection as parameter, Please make a video for your beloved students siva sir. thank you
Great video👍👍
Thank you 👍
very helpful...........
Thank you
Very helpful information sir thank you.. Could you pl provide a link for whole Plsql document.
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.
Welcome, please look into this video th-cam.com/video/qH47MCoWoNU/w-d-xo.html
Hey Siva, I want to learn full Oracle but getting lost in multiple videos, do you have a playlist from start to end?
Oracle basics, I am yet to cover, please stay tuned, will create a new playlist
@@SivaAcademy Thanks for reply, waiting for same
Please share the performance tuning videos.
@jitendra, very recently started the performance tuning series, will add more videos soon here. Here is the link plsql performance tuning: th-cam.com/play/PLb1qVSx1k1VrPd8FT8WI6Btu754TZjqIs.html
Superb sir....Please make videos on Hadoop technology..!
Yes bro, soon, i will be posting on Hadoop, please stay tuned
By using the %rowtype can we retrieve multiple records instead of single record at a time
No, rowtype can hold only one row, you need collection to hold multiple row
@@SivaAcademy thanks a lot
@@SivaAcademy please make videos on oracle cloud
Sure bro, please stay tuned
How to difference between collection function and function ?
Thanks Sir, We are in 2024. Does Oracle has big scope in job.
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.
My pleasure, thank you, sure please stay tuned
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.
Awesome👏✊👍
Thanks ✌️
compariosn of C languauge and PL/SQL was excellent
Thank you 💐
very good explanation sir
@Sagar, Thanks for your comment.
Great ,
can you please do a video on transposing table rows in columns.
1>Using pivot
2>Case
Please look into this video
th-cam.com/video/htZRVbSwEjw/w-d-xo.html
Sir>> COuld u please provide complete E2E trainning for Oracle sql and plsql, as am eagerly looking for it..tx
U didn't explained about bulk binding in this playlist. I think this playlist is incomplete.
Covered in another playlist, kindly check
Thanku.sir.explained very.well
Thank you
Thanks sir very useful
Welcome bro 💐
What is the major difference between ASSOCIATIVE ARRAY and NESTED TABLE AND VARRAY?
Please explain this question in experienced level
Sure, i will cover this in upcoming video about collection.
please make series for SQL performance tuning
@Sagar, Sure, I will upload soon, Please stay tuned.
Thank you Sir,
Tnq Very Much Sir...
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.
nice sir
Thanks and welcome
Thank you.
Welcome 🙏
❤