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