I need an Oracle SQL trigger that creates an audit when data is added to BB_PRODUCT and adds it to the BB_PRODUCTCHG_LOG table.

BB_PRODUCTCHG_LOG table structure:

CREATE TABLE BB_PRODUCTCHG_LOG

(

USER_ID VARCHAR2 (50),

CHG_DATE DATE,

PRODUCTNAME_OLD VARCHAR2 (25),

PRODUCTNAME_NEW VARCHAR2 (25),

PRICE_OLD NUMBER (5, 2),

PRICE_NEW NUMBER (5, 2),

SALESTART_OLD DATE,

SALESTART_NEW DATE,

SALEEND_OLD DATE,

SALEEND_NEW DATE,

SALEPRICE_OLD NUMBER (5, 2),

SALEPRICE_NEW NUMBER (5, 2)

);

The structure for the BB_PRODUCT table is the screenshot, thanks in advance!

CoursHeroTranscribedText

Transcribed Image Text:

BB_PRODUCT IDPRODUCT PRODUCTNAME DESCRIPTION PRODUCTIMAGE PRICE SALESTART SALEEND SALEPRICE ACTIVE FEATURED FEATURESTART FEATUREEND TYPE IDDEPARTMENT STOCK ORDERED REORDER BB_PRODUCT IDPRODUCT PRODUCTNAME DESCRIPTION PRODUCTIMAGE PRICE SALESTART SALEEND SALEPRICE ACTIVE FEATURED FEATURESTART FEATUREEND TYPE IDDEPARTMENT STOCK ORDERED REORDER