insert_update_using_triggers

PHOTO

Sun May 26 2024 17:29:08 GMT+0000 (Coordinated Universal Time)

create or replace Trigger mytrigger2
after insert or update on employee
begin 
  case  
   when inserting then 
 dbms_output.put_line('Record  inserting');
  when updating then
    dbms_output.put_line('record updating');
  end case;
end;
/

COPY

Save snippets that work from anywhere online with our extensions

Comments

DBMS

@signup

display_record_trigger prime_or_not swap_procedure experience_greater than_23 reverse_procedure check_deptno_for_cursor insert_update_using_triggers sum_two_sql checking_department_number_using _for_cursor Even or odd palindrome_procedure upper_cursor perfect_number factorial_function display_all_recors_using_explicit_cursor gcd_function value_error_exception display_after_trigger display_5_records_using_explicit_cursor salary_increased_20 implicit_cursors negative_exception power_number_1 fibonacci_procedures sal 3000 exception Sets 1 to 9 x n.n function ARGS_DEMO

insert_update_using_triggers

Save snippets that work from anywhere online with our extensions

Comments

More like this

DBMS

Browse more snippets >>

insert_update_using_triggers

Save snippets that work from anywhere online with our extensions

Comments

More like this

DBMS

Browse more snippets >>

Embed code snippet