oracle - Is before update trigger will fire if same values are updating into a row of column -


i using before update trigger each row on table, emp_table update 1 column modifid_date before loading table. if going update table same/existing values of row, trigger going fire or not?

condition in trigger: :new.modifid_dt := sysdate;

table values before update: john (name),4867 (id),20-04-2016 (modifid_dt) table values going update: john (name),4867 (id)

your trigger fired, no matter values using; example:

sql> create table testtrigger ( number)   2  /  table created.  sql> create or replace trigger before_update_trigger   2    before update on testtrigger   3    each row   4  begin   5      dbms_output.put_line('trigger fired!');   6  end;   7  /  trigger created.  sql> insert testtrigger values (10);  1 row created.  sql> sql> sql>  update testtrigger set = 10; trigger fired!  1 row updated.  sql>  update testtrigger set = 11; trigger fired!  1 row updated.  sql> 

Comments

Popular posts from this blog

magento2 - Magento 2 admin grid add filter to collection -

Android volley - avoid multiple requests of the same kind to the server? -

Combining PHP Registration and Login into one class with multiple functions in one PHP file -