In SQL for Oracle.

Can someone help me create a trigger to update the old price of an item and changing it to a new price, and then also having the date recorded.

(Can you proved the code for the trigger and also code for inserting the new values?

ERD creation with Item price his ksheet Query Builder BCREATE TABLE Iten price history( Icen Drice history history id DECIMAL (10) NDT NULL, item id DECIMAL (10) NOT NULL, old price DECIMAL (10,2), new price DECIMAL (10,2), date of change DATE, PRIMARY KEY (HISTORY_ID), mREIGNRBY (ITEM ID) REFERENCES item); script Output x1