SQL> 
SQL> column Spnum heading 'Supplier|Number' format 999
SQL> column Sname heading 'Supplier|Name' format a20
SQL> column Omonth heading 'Order|Month' format a10
SQL> column OrderNum heading 'Number of|Orders' format 999
SQL> column TotalUnits heading 'Total|Units' format 9,999
SQL> column TotalAmount heading 'Total|Amount' format $999,999.99
SQL> 
SQL> select O.Spnum, Sname, to_char(Odate,'mm/yyyy') Omonth, count(Onum) OrderNum, sum(Orderqty) TotalUnits, sum(Amtdue) TotalAmount from SupplierDetails S, OrderDetail O where S.Spnum=O.Spnum group by O.Spnum, Sname, to_char(trunc(Odate),'mm/yyyy') Omonth, count(Onum) OrderNum, sum(Orderqty) TotalUnits, sum(Amtdue) TotalAmount;
select O.Spnum, Sname, to_char(Odate,'mm/yyyy') Omonth, count(Onum) OrderNum, sum(Orderqty) TotalUnits, sum(Amtdue) TotalAmount from SupplierDetails S, OrderDetail O where S.Spnum=O.Spnum group by O.Spnum, Sname, to_char(trunc(Odate),'mm/yyyy') Omonth, count(Onum) OrderNum, sum(Orderqty) TotalUnits, sum(Amtdue) TotalAmount
                                                                                                                                                                                                                                                     *
ERROR at line 1:
ORA-00933: SQL command not properly ended 


SQL> commit;

Commit complete.

SQL> 
SQL> 
SQL> spool off