Create table of numbered words.
create table words ( 
  word_no integer,  
  word    varchar2(10) 
)Table created.
Insert first row into table.
insert into words (word_no, word) values (1, 'Hello')1 row(s) inserted.
Insert second row into table.
insert into words (word_no, word) values (2, 'World')1 row(s) inserted.
Create log table.
create table log (
  change_date  date,
  word_num     integer,
  old_word     varchar2(10),
  new_word     varchar2(10)
)Table created.
Create trigger.
create or replace trigger log_change_to_word
after update on words 
for each row 
begin 
  insert into log (change_date, word_num, old_word, new_word)
  values (SYSDATE, :old.word_no, :old.word, :new.word);
end;
ORA-24344: success with compilation errorMore Details: https://docs.oracle.com/error-help/db/ora-24344
Change first row of table.
update words
set word = 'Bonjour'
where word_no = 1ORA-00904: "Bonjour": invalid identifierMore Details: https://docs.oracle.com/error-help/db/ora-00904
Change second row of table.
update words
set word = 'Monde'
where word_no = 2ORA-00904: "Monde": invalid identifierMore Details: https://docs.oracle.com/error-help/db/ora-00904
Display log table.
select * from logno data found