Please confirm if this is correct and no need to initialize the type: TYPE sp_featv_arraytype IS TABLE OF NUMBER(25,0) INDEX BY PLS_INTEGER; l_sp_featv_array sp_featv_arraytype; SELECT c.objid BULK COLLECT INTO l_sp_featv_array FROM items c WHERE c.objid is not null;
Hi Sir, In a cursor introduction video you have showed one eg for nested table collection in that u have intialized with empty constructor.. but in that, while assigning values to that nested table type variable through select statement you are not using extend keyword or not initializing with null values in constructor..can you pls clarify how it works..?
@siva sir can you plz provide any pdf or material to practice scenario based questions in plsql as I will appear in the plsql interviews after 1 month or so my current experience is 2.2 yrs .....plz provide will be of great help...??
Hi Sir, have a doubt in this video you have assigned values to variable(1) = value, but in some other video you have assigned values to the (variable.last) position. Can you please explain??
Hi sir I have a doubt.. I want to find the day of the given date and if the day is Tuesday I want to raise an exception using raise_application_error using collections can you pls help on this. Many thanks 🙂
You can check the day using to_char(sysdate,'DAY') = 'TUE' then Raise application error, Please look into this video for date related details th-cam.com/video/E0NKvwuJu5c/w-d-xo.html
In one of my interviews I was asked how many types of tables are there in oracle? Is it possible for you to elaborate?
Please confirm if this is correct and no need to initialize the type: TYPE sp_featv_arraytype IS TABLE OF NUMBER(25,0)
INDEX BY PLS_INTEGER; l_sp_featv_array sp_featv_arraytype; SELECT c.objid
BULK COLLECT INTO l_sp_featv_array
FROM items c WHERE c.objid is not null;
Fantastic. So much confusion on this topic and made it so clear. Wonderful.
Thank you bro
Thankyou very much, appreciate for direct content not unnecessary topic explanation.
You're very welcome!
Thanks for clear explanation...Nice set of videos...once again Thank you very much...One of the best resource in the youtube for PL/SQL Developers
@Raju, Thanks for your comment :-)
Regards,
Siva
Hi Sir,
In a cursor introduction video you have showed one eg for nested table collection in that u have intialized with empty constructor.. but in that, while assigning values to that nested table type variable through select statement you are not using extend keyword or not initializing with null values in constructor..can you pls clarify how it works..?
@siva sir can you plz provide any pdf or material to practice scenario based questions in plsql as I will appear in the plsql interviews after 1 month or so my current experience is 2.2 yrs .....plz provide will be of great help...??
Thank you Siva, very clearly explained and clearly understood, appreciate you service.
Regards,
Sujaa
Thank you very much, its my pleasure
hI Sir, Kindly explain Details the all type pragma in oracle (Oracle 23c) in separate video's
One of the useful vdo tutorial... It's so short and crisp... Super work👏...
@Mohan, Thanks for your comment :-)
Hi Sir, have a doubt in this video you have assigned values to variable(1) = value, but in some other video you have assigned values to the (variable.last) position. Can you please explain??
You are great 🙏🙏 ,in depth knowledge
Thanks a lot
Hi brother.. How revert the elements once deleted?
Nice playlist Sir.. every topic nicely explained. Nice work on slides colour is decent but effective
@Karnaraj, Thanks bro :-)
You are a great teacher Sir (y)
Thank you
Hi sir I have a doubt.. I want to find the day of the given date and if the day is Tuesday I want to raise an exception using raise_application_error using collections can you pls help on this. Many thanks 🙂
You can check the day using to_char(sysdate,'DAY') = 'TUE' then
Raise application error,
Please look into this video for date related details th-cam.com/video/E0NKvwuJu5c/w-d-xo.html
Thanks Siva...
welcome bro
Great video Siva
Thank you
Good work sir... I'm waiting for Oracle cursor and Dbms jobs topic...
@Sridhar, Thanks for your comment.
Sure, Will post topics related to cursor, jobs etc... ... Stay tuned.
Great description. Thank you.
🙏
Shiva Sir Thanks alot 👌
Welcome bro 🙏
Hi Siva could you please explain multi dimensional nested table with structure
Sure, Please stay tuned.
Your collection is contains record having 1 value kindly make vedio on collection contains records of multiple columns
Sir Can you please explain Oracle hints
@Bhargava, sure, please stay tuned. i will post as part of performance related video series.
@@SivaAcademy Thanks for reply
Last point not clear in the last slide sir.