PL/SQL tutorial 73: Bulk Collect with SELECT-INTO statement in Oracle Database

Поделиться
HTML-код
  • Опубликовано: 4 ноя 2024

Комментарии • 26

  • @sharpazn
    @sharpazn Год назад

    Almost 100k subscribers, congratulations!!!!
    Hey do you have a series on Oracle Apex? it would be awesome!!!

  • @abidalica
    @abidalica 3 года назад

    This is just great stuff, thanks for the video, love and respect from Pakistan, just subscribed

  • @devinenibalaji9038
    @devinenibalaji9038 2 года назад +1

    Hi Manish.. good video... I have a doubt.. here the collection is holding data of type varchar .. if while extracting the data from employee table if it has any other data type other than varchar what would be the scenario... like it will still hold the records before error.. can you pls explain this...

  • @rk-ej9ep
    @rk-ej9ep 3 года назад

    Great bro

  • @rohinithakre872
    @rohinithakre872 3 года назад

    Manish sir...this was a simple example thanks for as usual awesome video...But in a real time senario for e.g. out of 10 records there is an error in one records...what happens in this situation???
    will whole bulk operation fails..? or what...really waiting for the ans for it

  • @yogitachoudhary9789
    @yogitachoudhary9789 4 года назад

    Your video was really very helpful, but i have a doubt. Suppose i want to select a single row with 5 cloumns from a table and put it into another table. So will the bulk select statement be helpful here?

  • @shravan9796
    @shravan9796 7 лет назад

    awesome manish bai...keep going

  • @daminirawat7627
    @daminirawat7627 2 года назад

    Hi,
    Could you please explain if you mentioned size is varchar2(20) of a type variable then how all 107 records are holding in this m confused please clear my doubt ??

  • @daggerdudes9211
    @daggerdudes9211 3 года назад

    hi bro could you tell me why you mentioned fname(idx) as we can get the data directly with fname itself

  • @singamsivagangireddy8175
    @singamsivagangireddy8175 7 лет назад +1

    Hi Manish, Can you please upload the videos on oracle database architecture.

  • @SureshKumar-uc4tz
    @SureshKumar-uc4tz 6 лет назад

    Thanks for this Bro

  • @hello2439
    @hello2439 4 года назад

    what happens when in bulk collect batch there is some error,will it gets failed?or continue to fetch??

  • @vickypatekar9532
    @vickypatekar9532 5 лет назад +1

    Hello Sir I cannot able to watch this video...As it Buffering

  • @pratikdixit1313
    @pratikdixit1313 2 года назад

    Why we have not initilized fname with constructor nt_fname() plz tell

  • @krom78
    @krom78 2 года назад

    I need use two tables en FROM clause, how do i make it?

  • @aleenshrestha8119
    @aleenshrestha8119 3 года назад

    can we use object type instead if nested table

  • @surjeetkarmakar3188
    @surjeetkarmakar3188 7 лет назад

    Hi Manish, Can you please make a video for managing different users(sys, HR etc) and there password for Oracle Database 12c Release 2 ((12.2.0.1.0) - Standard Edition 2 and Enterprise Edition). This will be a great help.

  • @photomyste3279
    @photomyste3279 4 года назад

    Why u didn't use the extend in nested array

  • @HM42162
    @HM42162 Год назад

    can we do this without using loop😊

    • @Rebellionrider
      @Rebellionrider  Год назад

      Yes you can use FORALL instead of FOR loop here.

  • @MASUDRANA-pq6pu
    @MASUDRANA-pq6pu 3 года назад

    what does use multiple columns ?

  • @lucasalvarez1472
    @lucasalvarez1472 3 года назад

    Excelente tutorial faltaría el subtítulo en español nomas!

  • @mahekaslam9448
    @mahekaslam9448 6 лет назад +1

    Hello sir,why this video is blurred m not able to view the videos

  • @stanika7752
    @stanika7752 6 лет назад

    Is this possible in bulk collect insert

  • @satya3233
    @satya3233 6 лет назад

    Hi Manish, Can you please upload the videos on oracle database architecture.