oracle plsql records and collections VARRAY collection methods 

Again, absolute class, clear, perfectly explained, thanks for such videos...loved it..have not found such explanation till date...🙏

Hi Siva, Oracle's latest documentation says, "EXTEND(n,i) is the only form that you can use for a collection whose elements have the NOT NULL constraint". But following program works perfectly fine where EXTEND and EXTEND(n) collection methods are being used on a collection variable whose elements in TYPE definition have NOT NULL constraint defined. DECLARE TYPE typ_varray IS VARRAY(10) OF NUMBER NOT NULL; v_typ_varray typ_varray := typ_varray(); BEGIN v_typ_varray.extend; v_typ_varray(1) := 10; v_typ_varray.extend(2); v_typ_varray(2) := 20; v_typ_varray(3) := 30; v_typ_varray.extend(2,1); FOR indx IN v_typ_varray.first..v_typ_varray.last LOOP dbms_output.put_line(v_typ_varray(indx)); END LOOP; END; /

Thank you so much Siva. Your explanation of topics and concepts are awesome. Please make a video on bind variables and ref cursor.

Your explanation is great, today you completely cleared my all doubts related to collection methods

Superb siva u cleared most of my doubts ur teaching skills are soo good, kindly make video on bind variable and refcursor

you are one hell of a guy. Kudos to u man.U have an exceptional talent to explain complicated concepts in a simple way. Keep doing a great job. I can even join classes if you are planning to take one.

Grateful for your effrots.

Thanks Siva...

Super ... very informative 👌... keep uploading such videos

Thank you so much Sir 😊😊

Very nice explanation..Can u please tell on which real time scenario..we have to go for varray.

Thank you Siva Sir

Nice explanation siva

Thank u for ur wonderful vdos...Content is very good...highly recommendable...just have a doubt @4:42...whats d difference between count and last method...both fetches same result

nicely explained

So at any point of time will count and last show same value for varray

Hi siva, hope you are doing good.... my query is....can we have a feature or functionality in Varray using that, there will be no need to initialise and array will get dynamically be extended upto the indexes which ever indexes or memory areas i need at run time?

Hi shiva garu, i was asked in one of the interview that, did you ever face a situation where element in present but the index is missing in a collection? Can you please let me know if that is even possible.

so suppose i have a Varray of 26 numbers from 1--26 and i want to delete the between 116 and 19? so what will be the code ?