编程规范与技巧oracle sql

《编程规范与技巧oracle sql》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、商务智能部编程规范与技巧OracleSQL当前版本：Ver0.6版本日期：2009年08月15日1商务智能部目录编程规范与技巧...............................................................................................................................1OracleSQL...........................................................................................

2、..............................................11.前言...............................................................................................................................................41.1边界定义.........................................................................................

3、.................................41.2原则定义..........................................................................................................................52.格式编排约定.......................................................................................................................

4、.........62.1基本要求..........................................................................................................................62.2编写规范............................................................................................................................62.2.1字段排列要求........

5、.................................................................................................62.2.2字段分割符’,’点书写位置要求......................................................................72.2.3字段别名‘AS’语句编写要求...........................................................................72.2.4SE

6、LECT子句排列要求........................................................................................72.2.5运算符前后间隔要求.............................................................................................82.2.6CASE语句的编写......................................................................

7、............................92.2.7DECODE语句：....................................................................................................92.2.8子查询嵌套编写规范...........................................................................................102.2