Oracle DML Error Logging Tables 

Thank you Shiva Sir, for all the awesome lessons you are posting.. Each and every videos of yours are very well explained.. pls continue sharing your knowledge

I would like to thank you for giving us such an excellent video tutorial. This includes the explanation from the very basics and included the reasons and cuases for each explanation. Looking forward for more tutorials.

Doing greate job Siva. Keep it up. I have a chalange i.e I need to generate the SQL query output as Excel. That should be automate no manual effort present once got automated.

Based on this, HCL interviewer asked me. Question: suppose you have 3 DML statements.If you want to run from 1st to 3rd, what will u do,doesn't matter if error occurred in any of them .? My Ans : I answered him ,I will create three error log table and use them with DML . Interviewer: I didn't hear about this concept.he immediately checked it on laptop n said yes u r correct .But we can do it by writting all three statement in seperate three blocks.

Sir it was the most appreciated video , thanks a lot and God bless you always . Many thanks Sir 👌👌👍 . It was a great learning Today 🙏🙏🙏💐😊😊

Awesome .always love your detailed videos

Thanks Siva sir, This is the new I learned today.. Thanks

You are just Amazing Siva. You teach with so much clarity

Thank you so much Siva garu.... Well explained ...:) . Please also post a video on forward declaration and overloading in sub programs...

Hello Siva... What a perfect video it is.... Can we use these all commands inside the procedure. As, I am doing multiple inserts by using the procedure.

Thanks brother. It helped me a lot

Many thanks for this video.

Thank you sir, It was a great learning Today

Thank you siva. You are great 👍.. May I know from which version oracle introduced this clause??

Great job.. Siva... really good Explanation...

You explained perfectly, again💯👍

Hello Siva , many thanks for posting valuable videos on Sql/plsql..really appreciate your interest towards databases...Here is a request from me . Could you post a video explaining lengthy explain plans of Sql queries?

Unique video on this topic... 🙏

Really superb shiva...

That is what I was looking for, Siva, don't know how do I say thanks.

Hello Sir, Firstly, I would like to congratulate you for doing a fantastic job by posting videos that are really helpful and insightful. Finally, I have a question regarding the use of the DML Error Loggin table, say I'm inserting n number of rows to my target table and I'm getting the ORA-00001: unique constraint (********) violated error for a row insertion, so would the other rows get inserted or the whole thing will get terminated and rolled back. Please reply to my question. Thanks

nice bro...doing good.Please also post a video on forward declaration and overloading in sub programs...

Thanks a lot ❤

Well explained.

Nice explanation bro... Thank u so much

Hi Siva, excellent vedio. Is it possible to use LOG ERROR INTO clause along with FORALL dml statement?

Nicely explain siva

Awesome explanation

Hi, A question: There is only one parameter which can be passed while using LOG ERRORS (). This get saved in column ORA_ERR_TAG$ of error logging table. Is there any way by which we can map a specific column of error logging table to a specific value?

Nice video . Sir what if a package compilation is taking very long time how we can rectify it.

Hi Siva thanks for the valuable videos you are making! may I know the video(s) link related to Oracle Lock mechanism? Thanks!

Can we use DML error loging concept on Clob data type values??

Very useful.

Nice vedio...

Hello shiva, thanks for this video. Error log table will work with insertion in collection also ? Where can we use this exception handling method

thanks, very handy!

Can we use it with bulk collect also?

Wobderfull

U r umazing sir i have one dout regarding in plsql packages let us assume i have one package contains many procedures and functions if we get any error how would i know which line error it is.??

i am using MERGE with subquery in Using clause. All the records to be loaded are deliberately made erroneous still my error log table is not showing any entry. ANy idea why

Siva , such a gem leq.....can you provide a bunch of question of sql for lateral interview purpose ?

Can we have the same logic for the Merge statement?

Can you please do a video on Merge v/s Update.

hey siva, hav'nt you posted this on your blog portal?

Constraints error can we handle this concept?

How to use with insert all log errors into OBJECT_NAME reject limit unlimited;

Hi Shiva, How to insert 10 millions of records from flat file into table can you give any example?