Комментарии:
Very nicely explained. Thank you, sir.
Ответитьhow to display and access records by storing in collections type
ОтветитьSir,please make video on hints
ОтветитьNice information.. thanks
ОтветитьThank you very much. Explained very clearly
ОтветитьInstead of loading the data from the rowtype into collection why dont you load the data directly to collection ? Is there any specific reason for that. Because here the processing for oracle enginee is increased by storing in rowtype scalar varialbe and then to collections !
ОтветитьNo words to say
ОтветитьCould you please help one video on additional features added to oracle higher than 11g version
Ответитьsuper explanation .. a big 👍
ОтветитьThank you, Siva, for your great content!
ОтветитьSupper
Ответитьwe are awaiting for your bind variable videos. when shall we expect that videos in your playlist?
ОтветитьHi Shiva, Your Video is Super informative as always. Kindly clarify a point, not related to Bulk Binding, but Binding Variable in general- Are all variables declared in a procedure treated as 'Bind Variable' ? If no, can you specify where all in a procedure should we explicitly define a variable as a bind variable. Thanks
ОтветитьGood one
ОтветитьAwesome video 👌 sir much liked
ОтветитьNice explanation.
Could you please tell me about the limit clause in bulk collect and how to decide the limit number?
Can we give tablename % row type while defining nestedtable type It should be of same data type like scalar or it can be composite also?
ОтветитьCould you please explain hints and how parallel hint work?
Ответитьpor favor podrias habilitar subtitulos para este capitulo, el video 2,3,4 y 5 no lo tienen. gracias.
ОтветитьHi Sir, in PLSQL collections videos all of with particular column to select and load the data to collection, so thought collection will store more rows with same datatype. But in this video we are storing different datatypes. Can you please explain?
ОтветитьThank you 🙏
ОтветитьIn addition to context switching reduction, undo,redo log file entry also can be reduced by bulk binding. Is that right sir?
ОтветитьGood teacher.
Clear,neat,Can understand easily
Appreciate the way you are explaining.its really helpful.
ОтветитьNice explanation. Thank you :)
Ответитьthankyou siva sir really very very well explained
ОтветитьHi Sir... One interviewer asked to write a code for to get all details from one table using bulk collect and insert into another table which will be insert 20,20 records... please do video for this...
ОтветитьCould you please make a video on object type
ОтветитьThank you ..!! Very good video.. pls upload part2 video
ОтветитьPlease do a video on bulk collect ,for all and explain plan
ОтветитьNice explanation but I could see only 2 videos on performance tuning... can you please point me if any other videos
ОтветитьDifference between bulk collect and bulk binding
ОтветитьCan upload function and stored procedure
ОтветитьWhen will you do part2 sir
ОтветитьVery useful. Thank you sir.
ОтветитьAwesome explanation..
can u please explain detail about bulk collect and forall...
Please make more videos on Performance tuning
ОтветитьGreat 👌👌👌👌. Pls make a video on collection exceptions.
ОтветитьPlease make one video about no copy clause in real time scenario.
Ответитьsir is there any more videos for pl/sql performance tuning
ОтветитьWhat an explanation brother... Awesome 👌👌
Can you please do an video :diff b/w ForAll and Bulk collection(asked in my one of the PLSQL interview)
Super as always!!👍👍
Looking forward to videos on topics like subprograms, sequence, analytical functions..
Keep up the good work! 🙏
Super
ОтветитьWhen will you do part2
ОтветитьNice video, when is the next part coming ?
ОтветитьPlease upload a videos on partition .
ОтветитьSuperb vedio....@manish @rohit@nehal
Pls subscribe this channel
Can you please upload video for function and bulk collect
ОтветитьThanks for describing the context switching and bulk binding in short.
Have doubt in bulk collection... If there is no records available while using "bulk collect into" clause, will it raise the exception.