Oracle PL/SQL Tutorials | Triggers in Oracle | by Mr.Vaman Deshmukh

Crystal clear explanation. Thanks a lot. ❤🎉

Thank you.. very useful..

Superb explanation. Thank you sir...

The last example was helpful.

I stoped going to college after watching this video.. 😊

Second example,
Old - 92000
New - 42000
When (new-old) , then we got negative value but here positive value....how...?

🙏🙏🙏🙏🙏thank you sir

thank you sir ,for outstanding teaching.

When i write same query on Oracle 10g edition
After executing : Trigger created with compilation errors.

Hello sir , thank you for giving us a great Knowledge

Wonderful sir, Very useful thanks sir

Please explain how use update query in insert trigger

Great Sir, You saved today in my project.

Ok po

thanks naresh sir !!!

Very well explained sir 👏 Understood everything related to Triggers..Thank you Sir 😊

Write PL/SQL block to create a trigger to update the records according to working days that is you can not update record in holidays
caN YOU PLEASE ANSWER THIS

Tnq so much sir

Thank you Sir.

Can anyone know how to take input in trigger and use those input in procedure which we call inside the trigger.

brilliant appreciate it!

Thanks you sir very much...
Clearing all the concept in one shot
One of the best and genuine explanation...

How to delete an already created trigger?

sir can we use triggers for checking date of birth entered by user to check whether he/she is above the age of 18

PLS HELP TO FIND A ORACLE DEVELOPER JOB AS A FRESHER OR INTERNSHIP

Hi, i have created a trigger for hr_hire and hr_fire. i am getting null values from parent to child. could you assist me where i wrong

create or replace trigger hr_tri before delete on hr_hire for each row
begin
insert into hr_fire(s_no,emp_id,emp_name,DOR,dept_id) values (s2.nextval,:new.emp_id,:new.emp_name,sysdate,:new.dept_id);
end;

How can we know the database name like hr.schema you mentioned it in. sir...

wow awesome ... thx for the sql trigger session ... understood!

Thanks a lot Mr. Vaman, your training course about triggers is very good, it help me a lot. to understand about this topic.

I want to take class by Mr. Vaman Deshmukh Sir, is it available or not Now live ?????Please Reply.

Thanks

Your video has really helped me sir, thanks a lot.

I am getting error ...
UPDATE ACCOUNT SET AMOUNT=AMOUNT-10000
Error report -
ORA-00001: unique constraint (HR.SYS_C0011145) violated
ORA-06512: at "HR.TRIG_ACC", line 2
ORA-04088: error during execution of trigger 'HR.TRIG_ACC'


can you plz tell whats the reason for this error.

it may late for me to get his video ,thanks a ton

U r Just reading the statements what u have handy. Try to explain things clearly.

really easy to understand , can you please explain about collections (nested table and varray)

thank you sir nicely explained

Y sequence starts from 6 in transaction table??

I am your fan sir

But what happen if the update query is not executed properly than also the message is display

How much does it take to learn Oracle completely?