oracle plsql records and collections VARRAY 

I used to write the code practically with out knowing conceptual knowledge, now understand theoretically.

Excellent !! Highly Appreciated Sir. Thorough knowledge of each topics with practical real time examples. Hats off to you !!

Covering almost all types of interview questions, 100% satisfied, please keep uploading on more and more and all Oracle concepts..

You are genius and explanation is very effective and simple, thank you very much for sharing such valuable information info for all of us with free of cost.

Watching in 2023 Aug ❤ Im about to leave this topic, but after watching this video , im curious to know more about VARRAY 🎉 thanks a lot sir for making such an informative video.

U r gem of a person. Thnk u so much

You deserve more subscribers! The explanation is unreal.

Number of video watched but I learned Varray collection from this video. Thanks a lot.

first video i have seen which explained very clear about oracle concepts...

Just wow!!! Got addicted in your way of explaining..❤️

Thanks Siva,, Very useful for your valuable videos.

Very clean and nice way explain.. Perfect way of teaching ..Very nice Shiva Sir . appreciate you!

Thank you Siva. So clear and useful.

Thank you so much for this detailed and clear explanation Siva...

Thank You, Sir. Nicely explained.

Sir please keep uploading videos i am loving watching them they are so crisp and clear👌

Thank you very much

Thank you

Thank you Siva, it was very helpful Sujaa

Very helpful and clear, best 💯👍😊

Hi Siva, I want to access the values of emp table and print the same using Nested table. Can you post an example here? because here in all the examples you are hardcoding the values and printing it.

Great explanation Sir..superb

Thank you sir 🙏

Great...brilliant explanation...

Very clear explanation

Many Many thanks for explain very very deep

Thanks a lot! Very clear explanation :)

Thanks alot Sir Damn Helpful 😍

Nice

Amazing explanation!

Great explanation

Instead of assigning each value,how to load data to varray from a normal table and later use the value from array for some conditional check?

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.

If we have rigth to initiallez by a boucl ??

Hi Siva one request if possible then please try to cover encryption and decryption in oracle as well , I know about these things , but I am sure I will learn again something good from you. And one more request kindly post something about oracle 18c ,21 c new features . Looking for your valuable post 🙏

Hi Siva One question regarding Oracle 19c +. What value does the collection store whose elements have the NOT NULL constraint defined? Example: DECLARE TYPE typ_varray IS VARRAY(10) OF NUMBER NOT NULL; v_typ_varray typ_varray := typ_varray(); BEGIN v_typ_varray.extend; -- What value will the v_typ_varray(1) will be storing at this point? END; In 12c it is NULL but in 18c and later, it doesn't seem to be NULL. Checked this value as DUMP(v_typ_array(1)) and it returns 'NULL' varchar2 value similar to DUMP(NULL), but it's actually isn't NULL. Please help.

awesome

Hi Siva, Can you provide the solution of below question: In an array of 7 number elements, find the second highest number. Kindly provide all possible solution?

Hi Sir , you are doing great videos , it is very easy to understand the concepts.can you make Plsql complete tutorial videos.

Sir please Make Vedios of all three collection of Fetching the Data of Table how actually it works

I need information about sql loader, utl file, xml, external table. Loading data into table or db and difference

nice tutorial... but after working in python for sometime. why they designed like this..they must have allowed auto extending

Varray Max size is 7 in video, but it takes more then 7

Pls do collection interview questions video sir