<p>Create a table PRODUCT with columns</p><p> PID NUMBER , PNAME VARCHAR2(50) , PRICE NUMBER , CATEGORY VARCHAR2(30)</p><p> Then rename column PNAME to PRODUCT_NAME and change PRICE datatype to NUMBER(10,2)</p>