<p>Create a table ORDERS with columns</p><p> ORDER_ID NUMBER , CUSTOMER_ID NUMBER , ORDER_DATE DATE , TOTAL_AMOUNT NUMBER</p><p> After creation:</p><p> * Add column STATUS VARCHAR2(20)</p><p> * Drop column TOTAL_AMOUNT</p><p> * Add column TOTAL_AMOUNT NUMBER(10,2) again</p>