oracle plsql records and collections VARRAY collection methods

oracle plsql records and collections VARRAY collection methods

[es.kamalvanshi]

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
LOOP

END LOOP;
END;
/

[Ins_]

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

[vijaydubey]

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

[KarthikRampur-qltd]

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.

[vaibhavraghuwanshi]

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

[swethagujja]

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.

[randomchitrakatha]

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

[pranabsahu]

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

[vijay]

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?

[vaniganapathi]

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

[iswaryarajendran]

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

[kkmm]

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

[katienefoasoro]

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 ?