You are a good teacher. Your videos are crisp and clear with good presentation and your concept articulation is par ahead than most of the teachers on RU-vid
Yes Sir, it is clear to me now, so lot of thanks , i have subscribe your channel sir, I joined this today , way of teaching is very fantastic, so thanks again
Thank you Siva.................even experienced developers will learn a lot from you. Can you please make a video on how to debug a collection used in stored procedures. Regards, Sujaa
parses a sentence and replaces each word with the following: first letter, number of distinct characters between first and last character, and last letter. For example, Smooth would become S3h. Words are separated by spaces or non- alphabetic characters and these separators should be maintained in their original form and location in the answer Siva Bro please these type of scenarios and give the solution for this challenge
Sir , By using PRAGMA AUTONOMOUS_TRANSACTION + TCL Command we can resolve the mutating error CREATE OR REPLACE TRIGGER TRG_MUTATION BEFORE UPDATE OF SAL ON EMP FOR EACH ROW DECLARE LV_MAX_SAL NUMBER; PRAGMA AUTONOMOUS_TRANSACTION; BEGIN SELECT MAX(SAL) INTO LV_MAX_SAL FROM EMP; IF :NEW.SAL
First of all I would like to thank you for sharing valuable knowledge . Can you please share me details about 1. how to debug a procedure or function using dbms_debug 2.How to capture multiple exception at one statement (not using when other or multiple when).
With in the body of trigger you can check the day using to_char function and then execute the logic if the day is Friday, please look into this video to know date format ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-E0NKvwuJu5c.html
Hello from Russia. I just have known a new word "lakh")) thank you. Tell me please, Why do we need a second condition in where clause in select statement (about deptno)?
Great explanation. But from what I have read Statement level triggers can also cause mutation error when the ON DELETE CASCADE clause has been used. But I have seen this in 11g. I haven't worked with 12c or above versions. Can You please confirm?
How it's making restriction not to update on emp_t table If sal greater than 1lakh because trigger has if-else condition on log table only. Please clarify.
Brother, Is this second condition(:old.job= 'CEO') is correct? Which you used it in if cluse... As per this condition it will update the record which is have job='CEO' value... But that should not happen right, because as per your explanation we need to update the records other than CEO record
Mutating error are not occurred in statement level trigger because, through these statement level trigger when we performing DML operations automatically data committed into the database.
Mutating Trigger can also happen on statement level triggers too. Condition is ON DELETE CASCADE relation should be there between the parent and child table. Even Functions can also cause Mutation error.
Hi Siva, One request, we use to find the link to the data used in the respective video's, but I am not finding it now, if it available it would help with the learning process, or am I missing something? Regards, Sujaa