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.
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.
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
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.
This is what I was searching since last 2-3 days. Thanks for sharing your knowledge !!
Ur my god sir .ur video made me to get a job in one of the mng company
Best explanation for collection with practical example..keep it up 👍
Hi! Thanks , Your videos make it easy to grasp the subject, good job!
best video to understand collection , but sir please explain "Associative Array" . Thanks so much
Excellent. Thanks for sharing
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.
Thank you bro!! Really helpful 😊😊👌👌
Could you share the link of the second part for the video Collection functions? please? I could not fid it
Thank you bro
very good explanation
Very Good Explanation.Please Upload the Videos for Bulk collect and ref cursors
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,Upload a Video Of regular expression
Bro how to get values for varray from user (dynamically) in oracle
Hi,
Thanks a lot sir, well explained .
Super explanation, thanks sir
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.
nice , now can understand clearly , what is collection, but i think "Associative Array" not described here
How to fetch no of records from cursor to collection?
Can anchored data types be used in temporary tables?
Hi ,
Where is third type Associative Array/Index by Table ? I Missed ?
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
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 ,can you please upload the associative array with bulk collect explanation asap?
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
I didn't understood, why you have declare array here sir??
Hi, you didn't explain the important topic i.e., Associate Array with example.
Send your email I'd I will explain
how to insert a record in collections in plsql
Thanks