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);
Bạn đang xem 6. - OCA OCP ORACLE DATABASE 11G A LL IN ONE EXAM GUIDE P37 DOC