create table words (word varchar2(20), date_added varchar2(20))
Table created.
create or replace trigger add_word
before insert on words
for each row
begin
:new.date_added :=TO_CHAR(CURRENT_DATE, 'DD-MM-YYYY HH:MI:SS');
end;
Trigger created.
insert into words(word) values('test')
1 row(s) inserted.
insert into words(word) values('hello')
1 row(s) inserted.
select * from words
| WORD | DATE_ADDED | test | 31-05-2018 04:44:25 | hello | 31-05-2018 04:44:33 |
|---|