how to create a trigger?
I want to create a trigger for the following table :
This is my code :
CREATE TABLE INVOICE (
Invoice_id number CONSTRAINT Invoice_id_pk PRIMARY KEY,
Invoice_date datetime NOT NULL DEFAULT CURDATE(),
Invoice_location varchar2(150) NOT NULL,
Invoice_order number CONSTRAINT Invoice_order_fk REFERENCES order_header(Order_id)
What would be the syntax for a trigger for the above table?
I would really appreciate any help
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)