This is the best tutorial series I have found for PLSQL. I've been studying and searching for quite a while. I have 3 books on PLSQL. This tutorial is perfect. Each subject is covered in perfectly sized modules. Good job! I hope you continue to put together these types of tutorials.
Hi, very good explanation. Can you provide example for Associative arrays as well and also could you explain when to use them, I mean among 3 collections when to use when.
can I put a variable in place of 5? Exp: Declare v_qtde integer := 5; type t_array1 is varray(v_qtde)......... !but this variable being of the type number or integer plsql complains that it is not integral.
Hi! You missed on the topic Associative array.. It'd have been better to include in this video itself so that we could have had a comparative study and understand the concepts better.
Hi Can you please help in following. How to assign the values as following student_ids(1).st_id := 5; student_ids(1).name := 'Kumar'; student_ids(1).marks := 50;
DECLARE TYPE ename_table_type IS TABLE OF employees.last_name%TYPE INDEX BY PLS_INTEGER; TYPE hiredate_table_type IS TABLE OF DATE INDEX BY PLS_INTEGER; ename_table ename_table_type; hiredate_table hiredate_table_type; BEGIN ename_table(1) := 'CAMERON'; hiredate_table(8) := SYSDATE + 7; IF ename_table.EXISTS(1) THEN INSERT INTO ... ... END; / Associate Array with example this must be an error way? Thank you so much
My only question is why we need array if we have cursor . We can same thing do with cursor. Can you tell me please what is main purpose of array and why we use in plsql. Thanks
Hi Satvinder, I'm glad you asked this question. If we use Cursor instead of an Array, The excecution control will have to switch between Program area to CURSOR area to fetch the each records (called context switch) and as a result, it will reduce the programming performance and also it's not advisible when it comes to handle larger amount of data. If we use bulk collect/collection/Array datatype then, it will contain bulk data within a program area and execute it until the program finishes. I hope it clarifies you. Thanks.
![ปฏิเสธไม่ไหว (Crush on you) - LIPTA feat. No One Else [Official MV]](http://i.ytimg.com/vi/NBw1jF342vw/mqdefault.jpg)
This was even better/clearer than the official Oracle tutorials, thanks!
This is the best tutorial series I have found for PLSQL. I've been studying and searching for quite a while. I have 3 books on PLSQL. This tutorial is perfect. Each subject is covered in perfectly sized modules. Good job! I hope you continue to put together these types of tutorials.
Ur my god sir .ur video made me to get a job in one of the mng company
This is what I was searching since last 2-3 days. Thanks for sharing your knowledge !!
Best explanation for collection with practical example..keep it up 👍
best video to understand collection , but sir please explain "Associative Array" . Thanks so much
Hi, very good explanation. Can you provide example for Associative arrays as well and also could you explain when to use them, I mean among 3 collections when to use when.
Excellent. Thanks for sharing
Hi! Thanks , Your videos make it easy to grasp the subject, good job!
Thank you bro
can I put a variable in place of 5? Exp: Declare v_qtde integer := 5; type t_array1 is varray(v_qtde)......... !but this variable being of the type number or integer plsql complains that it is not integral.
very good explanation
Very Good Explanation.Please Upload the Videos for Bulk collect and ref cursors
Could you share the link of the second part for the video Collection functions? please? I could not fid it
Very Good Explanation,Upload a Video Of regular expression
nice , now can understand clearly , what is collection, but i think "Associative Array" not described here
Thank you bro!! Really helpful 😊😊👌👌
Bro how to get values for varray from user (dynamically) in oracle
Hi! You missed on the topic Associative array.. It'd have been better to include in this video itself so that we could have had a comparative study and understand the concepts better.
Can anchored data types be used in temporary tables?
Hi,
Thanks a lot sir, well explained .
Super explanation, thanks sir
Hi Can you please help in following.
How to assign the values as following
student_ids(1).st_id := 5;
student_ids(1).name := 'Kumar';
student_ids(1).marks := 50;
Hi ,
Where is third type Associative Array/Index by Table ? I Missed ?
Hi ,can you please upload the associative array with bulk collect explanation asap?
How to fetch no of records from cursor to collection?
Brilliant
DECLARE
TYPE ename_table_type IS TABLE OF
employees.last_name%TYPE
INDEX BY PLS_INTEGER;
TYPE hiredate_table_type IS TABLE OF DATE
INDEX BY PLS_INTEGER;
ename_table ename_table_type;
hiredate_table hiredate_table_type;
BEGIN
ename_table(1) := 'CAMERON';
hiredate_table(8) := SYSDATE + 7;
IF ename_table.EXISTS(1) THEN
INSERT INTO ...
...
END;
/
Associate Array with example this must be an error way? Thank you so much
My only question is why we need array if we have cursor . We can same thing do with cursor. Can you tell me please what is main purpose of array and why we use in plsql. Thanks
Hi Satvinder,
I'm glad you asked this question.
If we use Cursor instead of an Array, The excecution control will have to switch between Program area to CURSOR area to fetch the each records (called context switch)
and as a result, it will reduce the programming performance and also it's not advisible when it comes to handle larger amount of data.
If we use bulk collect/collection/Array datatype then, it will contain bulk data within a program area and execute it until the program finishes.
I hope it clarifies you.
Thanks.
Thanks for the valid questions and superb answers
I didn't understood, why you have declare array here sir??
Thanks
how to insert a record in collections in plsql
Hi, you didn't explain the important topic i.e., Associate Array with example.
Send your email I'd I will explain