6 PLSQL Performance Tuning | Oracle FORALL | Oracle FORALL SAVE EXCEPTIONS | Part5

Поделиться
HTML-код
  • Опубликовано: 6 фев 2025
  • 6 PLSQL Performance Tuning | Oracle FORALL | Oracle FORALL SAVE EXCEPTIONS | Part5
    Collection playlist : • oracle plsql records a...
    --------------------------------------------------------------
    This channel is for learning Oracle SQL, PLSQL, DATABASE concepts, MYSQL, ETL, Mongo DB, Python,UNIX and related technologies.
    / sivaacademy
    Home page: sivakacademy.b...
    Telegram Channel : t.me/SivaAcademy
    --------------------------------------------------------------
    Home page: sivakacademy.b...
    List of all oracle SQL/PLSQL Interview questions sivakacademy.b...
    List of all PLSQL Scenario based Interview Questions sivakacademy.b...
    List of all Subscriber questions and answers sivakacademy.b...
    --------------------------------------------------------------
    Oracle Interview questions playlist • oracle interview quest...
    Oracle 18C New features playlist • Oracle 18C New Feature
    Oracle 12C New features playlist • Oracle 12C New Feature...
    Oracle PLSQL records and collections playlist • oracle plsql records a...
    --------------------------------------------------------------
    My video courses at UDEMY www.udemy.com/...
    --------------------------------------------------------------
    About Myself:
    ----------------------
    I am Siva, [LEARN | CODE | TRAIN | SHARE].
    Being in IT industry for more than 12+ years.
    In my day to day job, I work with database technologies including Oracle, Java, Python, MongoDB, talend and UNIX.
    I am passionate about "DATA", coding & training.
    In my spare time, I teach database technologies , ETL etc.
    I am very glad that you are reading my Profile, and I value your time as well as mine.
    Looking forward to see you in my videos
    For any questions, please drop me a mail at siva.k.academy@gmail.com
    --------------------------------------------------------------

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

  • @aartheesiva
    @aartheesiva Месяц назад +1

    Perfect and extra ordinary real time demo🎉🎉🎉🎉one of
    the best explanation

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

    I cant just understand how people's like is this much less for this video .Such a wonderful explanation never found in youtube .

  • @ajimsayyad7006
    @ajimsayyad7006 3 года назад +2

    I don’t think there would be a better platform than this to learn SQL plsql thank you siva

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

      Thank you bro

    • @MARehmanDBA
      @MARehmanDBA 3 месяца назад

      @@SivaAcademy Thanks brother. I want to contact you for some training

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

    Thanks siva , receiving the subscribers feedback and post the query tunning video
    Do post more related tunning videos 🥰

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

      Welcome bro, sure please stay tuned bro

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

    Good Video on Oracle FORALL SAVE EXCEPTIONS for Importing Purpose

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

    Thanks a lot...Sir...Appreciate effort taken to make these wonderful videos...

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

    very useful.. SQL GOAT.

  • @jrdesaria
    @jrdesaria 6 месяцев назад

    Great explanation!!!

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

    Most awaited video..
    Tnx Siva 👍

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

    Very useful information. Thank you sir 👍

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

    Fine video for forall but it would be more useful for all once if you have added how to identify the error record (through primary key) in bulk exception section in addition with error code and index.

  • @swamivivekananda-cyclonicm8781
    @swamivivekananda-cyclonicm8781 2 года назад

    Exceptional efforts.

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

    This is what I was waiting for....thanks

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

    Really awesome explanation sir

  • @rahitbasu460
    @rahitbasu460 6 месяцев назад

    Excellent sir

  • @hrishi2839
    @hrishi2839 Месяц назад

    Thanks man

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

    Great again... ❤️❤️

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

    Thanks a lot Siva

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

    great video .. thanks bro !!!!

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

    Good video. can you show in the sql%bulk_exceptions to print the error data or value.

  • @amitkarne5227
    @amitkarne5227 10 месяцев назад

    How can i insert the error value such as the actual name into the table

  • @SachinRathod-ie6qf
    @SachinRathod-ie6qf Год назад

    Dear Sir, I am having scenario two migration tables to be inserted in two respective master table. there is parent child in between the two tables. How to insert the data using outer loop and inner loop logic.

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

    Superb bro

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

    Nice explanation

  • @sonalipatil7976
    @sonalipatil7976 3 месяца назад

    nice video

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

    Thnks for the great video. can you confirm if we can use the same for bulk collect exceptional handling?

  • @krishnareddy2885
    @krishnareddy2885 3 года назад +3

    Hi sir..pls do a session on DBMS_SCHEDULAR 🙏🙏

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

      Sure bro, please stay tuned

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

    Nce video sir 🙏

  • @Karsh.y
    @Karsh.y 3 года назад

    Thanks Siva, You have started with the playlist of Regular expression (looking for more videos on it).
    Its a request if you could also start with playlist of Data Warehouse concepts and tools.

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

      sure bro, will try to add, kindly stay tuned

  • @Pritamdas-bg7fp
    @Pritamdas-bg7fp 3 года назад

    Thanks Siva .. Please create a one project videos

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

    Hello Sir. I love all of your awesome contents. Is it possible to make videos for oracle cloud integration.. oracle erp cloud as well as oracle reporting.

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

      Thank you bro, will add to upcoming list, please stay tuned

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

      @@SivaAcademy Thank you so much

    • @Karsh.y
      @Karsh.y 3 года назад

      @@SivaAcademy That would be great

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

    Please make a series on oracle apex

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

    Bro.. Please upload all videos related to Bulk collections concept

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

      Yet to record bro, will try to post soon, please stay tuned

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

    Please give a clarity on global temporary table bro

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

    sir i have some difficult questions and i dont know the answer these question please help me personally if it is possible to you

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

      Please send me mail at siva.k.academy@gmail.com

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

      @@SivaAcademy If i used unique constraint on a column so by mistake i insert some null values. So the unique constraint violate or not

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

      @@SivaAcademy I have two table
      table - A and table - B
      table-A has 0 numbers of record and table B has 2 numbers of record if i use cross join so what output will come ???

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

      No records will come as output

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

      No, unique constraint won't check null values, you can have any number of null values in unique column

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

    I want a tutorial on pragma restrict references