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.
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.
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?
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
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?
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
Hi Deepak, looks like no one follows the blog, so I didn't post the scripts, probably from next video onwards wherever needed I will add the scripts and post the links
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
Thank you Ravi, please stay tuned for more video's
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.
Thank you bro
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.
Sure bro I will post an video, please stay tuned
@@SivaAcademy ok
Also, if I want to generate the output as an xml. Can you please add this in the same video which you will create?
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.
👍👍💐
Good morning Dear Shiva Sir ....Sir ,I m still waiting for the real use of the GTT & PTT
Good morning Ujjwal, sure bro I am yet to record GTT, while posting I will add this post
@@SivaAcademy thanks a lot Sir
Welcome bro 🙏💐💙
Sir it was the most appreciated video , thanks a lot and God bless you always .
Many thanks Sir 👌👌👍 . It was a great learning Today 🙏🙏🙏💐😊😊
Its my pleasure, thank you 💐💐💐
Awesome .always love your detailed videos
Thanks Siva sir,
This is the new I learned today.. Thanks
My pleasure, thank you
You are just Amazing Siva. You teach with so much clarity
Thank you 🙏💐
Thank you so much Siva garu.... Well explained ...:) . Please also post a video on forward declaration and overloading in sub programs...
Welcome 🙏, please look into this video czcams.com/video/yUFA-g21_ug/video.html
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.
Thank you, yes you can use in procedure 👍
Thanks brother. It helped me a lot
Welcome bro
Many thanks for this video.
Welcome
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...
Thank you 👍💐
You explained perfectly, again💯👍
Thank you 🙏💐
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?
Thank you 🙏, sure, please stay tuned I will cover in upcoming videos
Unique video on this topic...
🙏
My pleasure 💐
Really superb shiva...
Thank you Suraj :-)
That is what I was looking for, Siva, don't know how do I say thanks.
Its my pleasure, welcome 🙏💐
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...
Thank you, please look into this video czcams.com/video/yUFA-g21_ug/video.html
Thanks a lot ❤
Well explained.
Nice explanation bro... Thank u so much
Welcome 🙏 bro
Hi Siva, excellent vedio. Is it possible to use LOG ERROR INTO clause along with FORALL dml statement?
Yes bro, you can use error log table in forall statement
Nicely explain siva
Thank you 🙏💐
Awesome explanation
Thank you 🙏💐
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!
Thanks bro, will cover soon
Can we use DML error loging concept on Clob data type values??
Very useful.
Thank you 🙏
Nice vedio...
Thank you
Hello shiva, thanks for this video. Error log table will work with insertion in collection also ? Where can we use this exception handling method
This is mainly to handle the error as part of dml statements
@@SivaAcademy will it work in plsql also for dml ?
Yes, it will work in plsql
thanks, very handy!
Welcome
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.??
dbms utility.format error backtrace
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 ?
Please look into this playlistczcams.com/play/PLb1qVSx1k1Vr0v4wVyvT3GEuA0J0M4xBm.html
Can we have the same logic for the Merge statement?
Yes we can have
Can you please do a video on Merge v/s Update.
Sure please stay tuned 👍
hey siva, hav'nt you posted this on your blog portal?
Hi Deepak, looks like no one follows the blog, so I didn't post the scripts, probably from next video onwards wherever needed I will add the scripts and post the links
Constraints error
can we handle this concept?
yes we can handle
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?
I guess SQL loader will work, however I will try and post with other possible options with time taken details