quote:

---

hi guys,

how would i write the following sql statments using pl/sql table--oracle?

SELECT to_char (orderdate, 'yyyymm') as ORDERDATE, SUM(total) as SUM, ordid, custid,...

thanks jonathan for yout help, but am getting this erro

" where c.Custid = o.Custid

ERROR at line 3:

ORA-00933: SQL command not properly ended"