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 = 1
ORA-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 = 2
ORA-00904: "Monde": invalid identifierMore Details: https://docs.oracle.com/error-help/db/ora-00904
Display log table.
select * from log
no data found