Basic Oracle SQL Tips

Maclean Liu(刘相兵

Basic Oracle SQL Tips
General SQL information Developers should know
Beginner level
Useful for all
Developers, DBAs & Designers
Taste of different features – SQL*Plus & PL/SQL
Look at in more detail (see References or Oracle doc)
Objectives:
Make you aware of Oracle SQL features
Improve programming style
Improve functionality & performance
Avoid pitfalls


Very important – No one likes sloppy code
Develop consistent SQL standard – Dev tools can help
Always have:
Header: program name, author, purpose, date, parms, tables
Document each SQL statement
Consistent indents, neatly line things up – equals, ANDs ORs
Suggestions:
Reserve words UPPER case (SELECT, FROM, WHERE)
User defined lower case (tables, columns) – also rem
Short alias names
Use courier new for e-mailing or documenting code
Apply good style to PL/SQL coding – use tools

Basic Oracle SQL Tips.ppt (558 KB, 下载次数: 14, 售价: 10 金钱)

2012-3-3 23:51 上传

点击文件名下载附件
售价: 10 金钱  [记录]

oracle_bin

thinks maclean

klby

其实这是个好东西。

coolingverse

谢谢ML的好资料

bj-jn

学习了！

307679393

好东西,就是太贵