Oracle 21c new features | PLSQL Extended Iterators FOR LOOP Enhancements Part2 | Iterand Mutability

[@ruchikagupta2012]

Thanks a lot for this much detailed and accurate videos.!

[@SivaAcademy]

Welcome

[@PrakshithaNithesh]

Hi @Siva Academy. I had these questions in latest interview. please help. 1.How to convert user input 345 to 3,4,5 using procedure 2. How to remove bracket values and return values as los angels only eg: los angels (los) Output: los angels

[@jeganbaskr4128]

Thanks for new knowledge.

[@SivaAcademy]

Welcome bro 🙏💐

[@pprasanna541]

Sir you explained the pipelined concept can you please explain how to access more than one column in pipe row.

[@pprasanna541]

Hi sir,can you please explain the topic function returning multiple values topic.I tried it but it showing in single row like string.

[@Keerthana-y2l]

Thank you very much for the video

[@SivaAcademy]

Welcome 🙏💐

[@mukkavijayalakshmi4984]

Please answer this Two tables Emp -having column names(empid, name deptid, salary) and Dept- having column names(depitd, dept name) Output should be : dept name & number of employees

[@munibhadranaidu3057]

Can you please give level by level top parent query?

[@virajraj935]

Sir, could you explain XMLAGG, COLLECT, WM_CONCAT FUNCTIONS?

[@shameempasha5006]

Nice topic

[@SivaAcademy]

Thank you

[@paonekumar9806]

Hi Siva, Thanks for informative video. Any job openings for PLSQL Developer with 3 years experience🙂

[@pprasanna541]

Hi sir, please explain function return multiple values.

[@SivaAcademy]

Sure, please stay tuned, will cover in upcoming videos

[@shineaway]

Please share collection, trigger,cursor interview questions in detail for experienced

[@SivaAcademy]

Already posted in interview question series, if the question you are looking for was not covered, please send me the questions to [e-mail], I will cover in upcoming videos.

[@shineaway]

@@SivaAcademy sure sir

[@jeganbaskr4128]

Hello.