PL SQL Collections || PL/SQL Tutorial for Beginners in Hindi

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

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

50% 1

A collection is an ordered group of elements having the same data type. Each element is identified by a unique subscript that represents its position in the collection.
PL/SQL provides three collection types −
Index-by tables or Associative array
Nested table
Variable-size array or Varray
Here we have also discussed different collection methods as well as different collection exceptions.
Please like & share the video.
Subscribe the Channel to keep watching interesting videos helpful for your career growth:
/ @codingglitz
--------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------
Checkout different playlists:
PLSQL Tutorial : • PLSQL Tutorial || PL S...
Learn DBMS & SQL : • SQL Tutorial for Begin...
SQL Interview Questions and answers: • sql interview question...
Java Interview Questions and Answers : • JAVA Programs for inte...
IT Career guidance: • Career Guidance
Interview Tips : • Interview Tips
IT Essentials and Tricks : • IT Essentials and Tricks
--------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------
Checkout Important videos :
Top 30 SQL Queries Interview Questions and Answers : • SQL Queries Interview ...
Top 50 SQL Concepts Interview Questions and Answers : • SQL Interview Question...
Employee earning maximum salary in each department query : • SQL Query to find Empl...
How to delete duplicate rows from any table (2 different solutions): • SQL query to delete du...
How to find Nth highest salary (3 different solutions): • SQL query to find Nth ...
Tricky SQL Queries Part1 : • SQL Tricky and Importa...
Basics of Database : • What is DBMS? Learn B...
SQL OPERATORS : • Operators in SQL || S...
AGGREGATE FUNCTION: • Aggregate function ||...
GROUP BY : • GROUP BY & HAVING || ...
Solve any Date related query : • How to Solve any SQL Q...
How to use Substring : • Substrings in SQL | L...
How to practice SQL Queries in local / Install Database in local : • How to Install Oracle ...
IT Jobs without Coding : • IT Jobs without coding...
--------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------

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

29 сен 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@prakhardubey_ Год назад

Great video! This was incredibly helpful and informative. Thank you for breaking down the topic so clearly and providing practical examples. Keep up the fantastic work!

@aniketjagdale7765 12 дней назад

Bro everything was good but you didn't explain anything about collection inbuilt exceptions provided by Oracle for which I have visited your video.

@CodingGlitz 12 дней назад

Noted

@ankitapathak5072 Месяц назад

Keep it up sir....very well explained

@CodingGlitz Месяц назад

Glad it helped 🙂

@srishtidixitsd Год назад

Here what i dont understand is: In the last index by collection --- we indexed our table with varchar values, then how are we iterating through it using for i in 1.. marks.count ? Because index is by varchar, how are we iterating via number?? Correct me if i am wrong

@srishtidixitsd Год назад

I am sorry I don't understand this for loop in the last program.-- i believe what should work is Indexval:= marks.first; While indexval is not null loop Dbms_output.put_line('Marks of' || Indexval || 'is' ||marks( indexval)); Indexval:= marks.next(indexval); End; My question to be precise In for i in 1.. marks.count How is 1 working here? Since index is of varchar type?? Hope you understand. If there is some other concept or mechanism to it. Do let us know. Thanks for your content..It's really helpful though.