1.书写格式    示例代码:  
  存储过程SQL文书写格式例
  select
  c.dealerCode,
  round(sum(c.submitSubletAmountDLR + c.submitPartsAmountDLR + c.submitLaborAmountDLR) / count(*), 2) as avg,
  decode(null, 'x', 'xx', 'CNY')
  from (
  select
  a.dealerCode,
  a.submitSubletAmountDLR,
  a.submitPartsAmountDLR,
  a.submitLaborAmountDLR
  from SRV_TWC_F a
  where (to_char(a.ORIGSUBMITTIME, 'yyyy/mm/dd') >= 'Date Range(start)'
  and to_char(

文章来源:
http://blog.donews.com/yoyozy/archive/2005/11/04/615205.aspx