ORACLE 错误集锦

1.QQ:"ORA--00979 GROUP BY 表达式错误"\

AN:group by 使用时必须列出所有在select 和order by后面出现的字段除了聚合函数外.

eg：

select obj.stock_type as stock_type,
  obj.stock_detail_id as stock_detail_id,
  sum(obj.qty)
  from MT_INV_STOCK obj 
 group by ,obj.stock_typ

这个就会产生00979错误，应该改成

select obj.stock_type as stock_type,
  obj.stock_detail_id as stock_detail_id,
  sum(obj.qty)
  from MT_INV_STOCK obj 
 group by ,obj.stock_typ,obj.stock_detail_id