INSERT A ROW INTO THE PRODUCTS TABLE, CALCULATING THE PRODUCT_ID TO BE 100 HIGHER THAN THE CURRENT HIGH VALUE

6. Insert a row into the PRODUCTS table, calculating the PRODUCT_ID to be

100 higher than the current high value. This will need a scalar subquery:

insert into products values ((select max(product_id)+100 from products),'11G DBA2 Exam Guide', 'INACTIVE', 40, sysdate-365, 0);