Oracle PLSQL - BULK Extract, Insert, Update and Delete

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

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

  • @pradeepmca
    @pradeepmca 3 года назад +1

    Thanks for this video. Just want to mention that there is max buffer size for DBMS output of 1M.Will get buffer over flow error ORA-20000 beyond 1M.

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

    Hi, tq. Will use the same query for getting multiple columns and multiple conditions to extract millions of data?

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

    While updating record in table the table will be lock. On production all process will be stop?

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

    Hi bro, kindly guide me how to fetch million rows using bulk collect from select query with multiple tables which are used join conditions.. ??

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

    Done - bulk collect, limit n, forall, returning

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

    Sir
    After SQL witch front end you teach us

    • @oratrainings
      @oratrainings  3 года назад +1

      Java and Python in plan

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

      @@oratrainings I want to learn paython.

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

      @@oratrainings I have a oracle SQL + oracle forms & report 6i certificate and make some projects. Now I want to learn paython for online softwares.

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

      @@oratrainings I like your teaching and help you to increase your views and watch time.