Collections in Oracle PLSQL

Подписаться 12 тыс.

Просмотров 62 тыс.

50% 1

Complete Oracle PL/SQL Tutorial for Beginners Playlist here
• ORACLE PL SQL Tutorial...
**************************************************
Composite DataType - Collections in Oracle PL SQL
1. Difference Between Records and Collections
2. Types of Collections in Oracle
3. VARRAYS
4. Nested Table
3. Associative Arrays / Index BY Tables
4. Multi Dimensional Arrays Using Collections and Records

Опубликовано:

29 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 37

@CB-xk6ce 2 года назад

This was even better/clearer than the official Oracle tutorials, thanks!

@rexjuggler19 3 года назад

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.

@sushmitapriya2250 5 лет назад

This is what I was searching since last 2-3 days. Thanks for sharing your knowledge !!

@mmohan692 2 года назад

Ur my god sir .ur video made me to get a job in one of the mng company

@affanpk002 4 года назад

Best explanation for collection with practical example..keep it up 👍

@mohan1958 3 года назад

Hi! Thanks , Your videos make it easy to grasp the subject, good job!

@vijayrajjakhmola4615 3 года назад

best video to understand collection , but sir please explain "Associative Array" . Thanks so much

@SudhirBhajnawale 6 лет назад

Hi, Thanks a lot sir, well explained .

@mauricioroldanramirez821 8 месяцев назад

Could you share the link of the second part for the video Collection functions? please? I could not fid it

@ptnaidu525 6 лет назад

Super explanation, thanks sir

@adwaitsharma8421 5 лет назад

Thank you bro!! Really helpful 😊😊👌👌

@KabergOficial 3 года назад

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.

@krishnad9847 6 лет назад

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.

@RAMPRASAD-sv7is 5 лет назад

Very Good Explanation.Please Upload the Videos for Bulk collect and ref cursors

@satya3233 6 лет назад

Very Good Explanation,Upload a Video Of regular expression

@deepaktheproudindian 4 года назад

Can anchored data types be used in temporary tables?

@bsramkrishna3980 2 года назад

How to fetch no of records from cursor to collection?

@kumar-bi1to 2 года назад

Excellent. Thanks for sharing

@kumarmacha Год назад

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;

@KrishnaPaneri 6 лет назад

Thanks

@prabhakarraju1523 3 года назад

very good explanation

@sujith.g8778 Год назад

Bro how to get values for varray from user (dynamically) in oracle

@rakeshk681 3 года назад

Hi , Where is third type Associative Array/Index by Table ? I Missed ?

@divyaarora2887 4 года назад

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.

@sharmisthasahoo5066 4 года назад

Hi ,can you please upload the associative array with bulk collect explanation asap?

@musandlala7991 4 года назад

Brilliant

@Suryavishaal 5 лет назад

I didn't understood, why you have declare array here sir??

@avinashsripathi2873 Год назад

how to insert a record in collections in plsql

@vijayrajjakhmola4615 3 года назад

nice , now can understand clearly , what is collection, but i think "Associative Array" not described here

@satvinderbhangu361 4 года назад

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

@sriramkolanji2158 4 года назад

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.

@kumar-bi1to 2 года назад

Thanks for the valid questions and superb answers

@Sn46312 5 лет назад

Hi, you didn't explain the important topic i.e., Associate Array with example.

@sivarajumandam8613 4 года назад

Send your email I'd I will explain

@HalimilFathi 4 года назад

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