Trigger inserting new row after update of another table in Oracle SQL Developer

Question

I would like to create trigger which should create new row in table INVOICES after a new row is created in FREIGHTS table. The trigger should get value from table FREIGHTS and put it in column in table INVOICES.

For now it looks as follows:

create or replace TRIGGER NewInvoice
AFTER INSERT ON FREIGHTS
FOR EACH ROW
BEGIN
 INSERT INTO INVOICES(id, netvalue, grossvalue, tax, receipient)
 SELECT '1', '1', weight, '1', '1'
 FROM FREIGHTS
END;

The error is at the final END statement.

Thanks in advance for your support ;)

Try: INSERT INTO INVOICES(id, netvalue, grossvalue, tax, receipient) VALUES( '1', '1', :new.weight, '1', '1' ); — krokodilko
– krokodilko, Commented Jun 1, 2016 at 17:58

OldProgrammer · Accepted Answer · 2016-06-01 17:58:27Z

1

Assuming weight is a column in FREIGHTS table:

create or replace TRIGGER NewInvoice
AFTER INSERT ON FREIGHTS
FOR EACH ROW
BEGIN
 INSERT INTO INVOICES(id, netvalue, grossvalue, tax, receipient)
  values ('1', '1', :new.weight, '1', '1');

END;

Maybe read the docs?

answered Jun 1, 2016 at 17:58

OldProgrammer

12.2k4 gold badges27 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Trigger inserting new row after update of another table in Oracle SQL Developer

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related